[osCmax V2.0.25] admin catalog/products faster query mod?

[MrE03]

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.

[pgmarshall]

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,

[MrE03]

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!

[pgmarshall]

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

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

Regards,

[MrE03]

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?

[pgmarshall]

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,

[MrE03]

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...

[pgmarshall]

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,