osCmax v2.5 User Manual
Results 1 to 8 of 8

admin catalog/products faster query mod?

This is a discussion on admin catalog/products faster query mod? within the osCmax v2 Customization/Mods forums, part of the osCmax v2.0 Forums category; Is there any contributions out there where it can change the way admin/catalog is displayed. I have over 50k items ...

      
  1. #1
    osCMax Testing Team
    Join Date
    Jun 2004
    Posts
    258
    Rep Power
    0


    Default admin catalog/products faster query mod?

    Is there any contributions out there where it can change the way admin/catalog is displayed. I have over 50k items and it takes forever to load. Clicking one by one makes it even more difficult. The dropdown on the top right isn't too helpful unfortunately.

  2. #2
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Default Re: admin catalog/products faster query mod?

    There is a admin page split here - osCommerce Community Add-Ons - which I was hoping to get into v2.5 but we are now under code freeze so will have to go into v2.6. Should enable you to split the page query when using categories.php. Let me know how you get on with it ... I would start with mastergigi's version from 4 Nov 2006. Regards,
    pgmarshall
    _______________________________

  3. #3
    osCMax Testing Team
    Join Date
    Jun 2004
    Posts
    258
    Rep Power
    0


    Default Re: admin catalog/products faster query mod?

    I installed the categories box optimization osCommerce: Optimize categories box but I don't believe it really helped much in the field of making the admin catalog load quicker. However it did cut the queries on the catalog side.

    I will give the one you recommended a try as I didn't even see this contrib, thanks!

  4. #4
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Default Re: admin catalog/products faster query mod?

    I tend to advise people to NOT have category counts turned on - especially in large stores ...

    Configuration -> My Store -> Show Category Counts -> False

    Regards,
    pgmarshall
    _______________________________

  5. #5
    osCMax Testing Team
    Join Date
    Jun 2004
    Posts
    258
    Rep Power
    0


    Default Re: admin catalog/products faster query mod?

    the category counts I have off, well it appears after installing this contrib, it somehow is loading easypopulate very slow and having a really slow export/import. Is there a way to troubleshoot this?

  6. #6
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Default Re: admin catalog/products faster query mod?

    Hmm... After install the page spliting your easypopulate is running slowly ... I can not see how these are related at all ... however you could use MySQL to monitor for slow queries. Regards,
    pgmarshall
    _______________________________

  7. #7
    osCMax Testing Team
    Join Date
    Jun 2004
    Posts
    258
    Rep Power
    0


    Default Re: admin catalog/products faster query mod?

    So I installed this mod, and I'm not sure what I'm supposed to notice, because it takes like 5 minutes for me to get into categories.php. It appears it didn't make any difference at all...

  8. #8
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Default Re: admin catalog/products faster query mod?

    The pageination should limit the query to a set number of records by using LIMIT on the $products_query. I assuming you have your products in sub-folders so we may need to look at slow queries in MySQL to see which one is taking so long (and why).

    Regards,
    pgmarshall
    _______________________________

Similar Threads

  1. SSL Setup for (admin) catalog/admin/includes/configure.php?
    By sushiboiiii in forum osCmax v2 Installation issues
    Replies: 0
    Last Post: 05-13-2009, 03:35 PM
  2. Replies: 2
    Last Post: 07-05-2007, 07:06 AM
  3. FAN - Faster Admin Navigation
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 02-11-2007, 11:02 PM
  4. FAN - Faster Admin Navigation
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 02-11-2007, 04:01 PM
  5. FAN - Faster Admin Navigation
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 02-11-2007, 09:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •