categories.php - Catgories on main page takes too long to load and timesout....

[ChrisUCF99]

Hello,

 

I'm running the latest OSCommerce on Windows Server 2003, with PHP 5 and MySQL 4.1.

 

I am running on a dedicated server with dual zeon 3.2GHz processors and 4GB of ram... the server "should" kick ass... but its not.

 

I loaded everything perfectly, and the site was fast initially. I then loaded up 130,000 products and the man page came to a crawling hault. I've tracked the issue down to the categories box trying to load. It's just taking forever and eventually timeouts and the page doesnt load. As a test, I added the categories drop down contribution and the page loads fast again, however, I do not like a drop down menu as I have tons of categories/sub categories and its just not practicle for the site. Is there anything that can be done to the categories.php file to speed up the loading? Any help would be greatly appreciated.

[dittones]

ChrisUCF99,

That is a lot of data to push...Their is a forum thead...in tips and tricks

by chemo he has some good speed tips...

If you have access to my.ini file the mysql control file you can do adjustment to take advantage of the memory...also turn on gzip and

cashing in the ADMIN...Also put the mysql on a seperate drive (spindle)...

I hope this helps you

dittone.com

Roman

[♥Monika in Germany]

I assume you have show category counts set to true ... go to admin -> configuration -> my store and set to false

[boxtel]

Hello,

 

I'm running the latest OSCommerce on Windows Server 2003, with PHP 5 and MySQL 4.1.

 

I am running on a dedicated server with dual zeon 3.2GHz processors and 4GB of ram... the server "should" kick ass... but its not.

 

I loaded everything perfectly, and the site was fast initially. I then loaded up 130,000 products and the man page came to a crawling hault. I've tracked the issue down to the categories box trying to load. It's just taking forever and eventually timeouts and the page doesnt load. As a test, I added the categories drop down contribution and the page loads fast again, however, I do not like a drop down menu as I have tons of categories/sub categories and its just not practicle for the site. Is there anything that can be done to the categories.php file to speed up the loading? Any help would be greatly appreciated.

 

I would argue that having tons of categories/subcategories is not practicle for your customers.

Even amazon has about 34 main categories so with tons of them, what are you selling?

[ChrisUCF99]

I assume you have show category counts set to true ... go to admin -> configuration -> my store and set to false

 

 

I love you! You did it! Speed it back up... like night and day!