Too Many Categories to Products Cross Referneces

[Thieving_Gypsy]

My latest site has 550 products, 7500 categories and 37000 products to categories records. This is making the site very slow to drill down from the top level category to the next and eventually get to the product.

 

Has anyone come a across a contrib that can speed up this process? If I can;t find anything I'm going to have to seriously think about either denormalising the data or writing something bespoke for this shop.

 

Thanks

 

Andy

[MarcoZorro]

There are a number of contributions in the contrib section...

 

You could also turn off category counts... the number of products you are using isnt that large

[ozEworks]

consider adding more indexes

[Thieving_Gypsy]

Can you let me know which contributions will help?

 

Category counts are off... and I've added some indexes but I can't see that they'll help much.

 

From switching on logging I can see that every category is being queried from the database one at a time - and it's not in categories.php - just not found where yet!! I'm convined once I've located this and stopped it then the performance will not be an issue.

 

Andy.

[Thieving_Gypsy]

Thanks to MarcoZorro and FlyingKites - but I have found the problem and solved it.

 

I turned on all the debugging and logging and found that there was a some code in the sts_user_code.php file that was hitting every single category in the system (7500 approx). I've commmented it out and the page time is now 0.186 seconds down from 15!!!

 

ANdy

[Tuan Le]

I turned on all the debugging and logging and found that there was a some code in the sts_user_code.php file that was hitting every single category in the system (7500 approx). I've commmented it out and the page time is now 0.186 seconds down from 15!!!

 

ANdy

Andy,

 

I am having similar issues as yours with my webstore. Can you please help me with further details on how to comment out the "codes" you referrenced above? I appreciate your help very much.

 

-Tuan