Lots of products = REALLY SLOW!

[Sebastien]

Hi. I'v installed osCommerce 2.2 without much problem and i have been modifying it since. Now although it's my first stabs at PHP and MySql, being a programmer, it wasn't too hard to get the hang of it. Now for my store, one of my suppliers has a CSV database of their products which i used to import into my store (much simpler than typing in thousands of products).

 

The problem is that once i'v entered all the products (~7000 of them) the store runs slow as hell. It pretty much takes ~15 seconds to load any page and that's off my local machine webserver (don't even want to imagine how slow it's going to be off the server. :cry:

 

So i am wondering if anybody has an idea as to why it would be so slow and what can be done about it. My current guesses are the "What's New" feature and "Telling how many products in each category". Now i won't put all 7000 products in the final store but i am still worried that as i get more suppliers and grow, that the store won't be able to keep up.

 

Thanks.

[Jan0815]

Did you enable the osC-cache system? It should help a lot.

 

You can also try changing this in catalog/includes/application_top.php:

 

// Categories Box: recursive products count

 define('SHOW_COUNTS', 'true'); // show category count: true=Yes False=No

 define('USE_RECURSIVE_COUNT', 'true'); // recursive count: true=Yes False=No

 

To:

 

// Categories Box: recursive products count

 define('SHOW_COUNTS', 'false'); // show category count: true=Yes False=No

 define('USE_RECURSIVE_COUNT', 'false'); // recursive count: true=Yes False=No

 

And tell us if it helps.

[Sebastien]

Thanks Jan.

 

Was somehow suspecting the product counting was one of the reasons. I'v also found another thread on the subject and seems like adding some indexes to the database may help. So i'll look into that too. So i'll try some indexing, turning the cache on and removing the product counting tonight when i get home (yep, my store is my part time home business so i have to deal with my real job in daytime :wink: )

 

Thanks,

Sebby.

[wizardsandwars]

yep, my store is my part time home business so i have to deal with my real job in daytime  

Isn't this true for everyone?

[Sebastien]

Allright, turned on caching and turned off product count. What made a massive description was the product count. I'm having an issue with caching as it seems it's not able to create the cache files. I'v created the tmp directory but maybe i did it at the wrong place. Where is the tmp directory supposed to be located?