Major speed issues - can someone help me?

[kittylitter]

I have over 2,000 products in my web store (www.hypnozebra.com) and it takes up to 6 seconds for each page to load. This is driving me insane, because I know that people won't tolerate that kind of slowness.

 

I have seen other oscommerce sites with 10,000+ products and they don't seem to be having any problems at all. What gives?

 

If anybody needs to know anything about my server just let me know and I'll fill in any blanks.

 

Server OS: Linux 2.6.10-1.771_FC2smp

Database: MySQL 3.23.58

Server Up Time: 16:23:51 up 94 days, 20:50, 0 users, load average: 0.00, 0.01, 0.00

HTTP Server: Apache/2.0.51 (Fedora)

PHP Version: 4.3.11 (Zend: 1.3.0)

[crash3903]

I have over 2,000 products in my web store (www.hypnozebra.com) and it takes up to 6 seconds for each page to load. This is driving me insane, because I know that people won't tolerate that kind of slowness.

 

I have seen other oscommerce sites with 10,000+ products and they don't seem to be having any problems at all. What gives?

 

If anybody needs to know anything about my server just let me know and I'll fill in any blanks.

 

Server OS: Linux 2.6.10-1.771_FC2smp

Database: MySQL 3.23.58

Server Up Time: 16:23:51 up 94 days, 20:50, 0 users, load average: 0.00, 0.01, 0.00

HTTP Server: Apache/2.0.51 (Fedora)

PHP Version: 4.3.11 (Zend: 1.3.0)

 

is your site running a ssl connection - if so this will slow your site down as it has to send the data over an encrypted connection and back again

[kittylitter]

is your site running a ssl connection - if so this will slow your site down as it has to send the data over an encrypted connection and back again

 

Nope - no SSL.

[Guest]

First, you have to determine the source of the performance degradation. Most likely it will be a query using unindexed columns in the WHERE clause, large joins, or just plain bad syntax.

[ozcsys]

I have over 2,000 products in my web store (www.hypnozebra.com) and it takes up to 6 seconds for each page to load. This is driving me insane, because I know that people won't tolerate that kind of slowness.

 

I have seen other oscommerce sites with 10,000+ products and they don't seem to be having any problems at all. What gives?

 

If anybody needs to know anything about my server just let me know and I'll fill in any blanks.

 

Server OS: Linux 2.6.10-1.771_FC2smp

Database: MySQL 3.23.58

Server Up Time: 16:23:51 up 94 days, 20:50, 0 users, load average: 0.00, 0.01, 0.00

HTTP Server: Apache/2.0.51 (Fedora)

PHP Version: 4.3.11 (Zend: 1.3.0)

 

 

First off you need to install one of the thumbnail contributions as your images are pretty heavy. Second you should take a look at the thread found HERE

[kittylitter]

First off you need to install one of the thumbnail contributions as your images are pretty heavy. Second you should take a look at the thread found HERE

 

 

I found that thread earlier today and have implemented several of the ideas... I disabled banners, turned cache on, and removed category counts.

 

Speed has more than doubled and is now well within acceptable ranged.

 

I will tool around with it some more later.

 

As for the thumbnails - I don't think that the images are large enough to cause any serious problems - and the page took forever to load before the images even start popping up anyway. :) I did make thumbnails of everything, though (manually - for an undisclosed reason) in order to speed things up.

[ozcsys]

I found that thread earlier today and have implemented several of the ideas... I disabled banners, turned cache on, and removed category counts.

 

Speed has more than doubled and is now well within acceptable ranged.

 

I will tool around with it some more later.

 

As for the thumbnails - I don't think that the images are large enough to cause any serious problems - and the page took forever to load before the images even start popping up anyway. :) I did make thumbnails of everything, though (manually - for an undisclosed reason) in order to speed things up.

 

 

Well your thumbs are pretty heavy for dialup customers most seem to be in the 15-20k range when you really should be down in the 2-8k range and the one on this page

 

http://www.hypnozebra.com/catalog/index.php?cPath=0_56_365

 

is over 71k

[kittylitter]

Well your thumbs are pretty heavy for dialup customers most seem to be in the 15-20k range when you really should be down in the 2-8k range and the one on this page

 

http://www.hypnozebra.com/catalog/index.php?cPath=0_56_365

 

is over 71k

 

 

 

Right - I was making a change at that point. :)

 

I had tweaked oscommerce to pull the thumbnail image from a different folder than the full size one, and have been converting images to thumbnails today. At this moment the page is just shrinking the full size version of the pic (hence the large file size) but when I set it back to the way I had it before the files will be around 5k each.