Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Major speed issues - can someone help me?


kittylitter

Recommended Posts

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)

Link to comment
Share on other sites

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

Regards

 

Mark A Reynolds

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...