Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Performance Issues


Drimmie

Recommended Posts

My company is running OSC w/ a DB of close to 2,000 products. OSC works fine, but is very slow in loading. What can be done about this? Im still going thru the learning process and need some help here.

 

Thank you

Jason

Link to comment
Share on other sites

The size of the DB shouldn't matter, unless you're trying to list all 2000 products on one page.

 

It may be that your host is slow - mine is quite fast. (See my WWW link below.)

 

The other possibility is that you have something on your pages that loads slowly, such as an off-site banner ad.

Link to comment
Share on other sites

The size of the DB shouldn't matter, unless you're trying to list all 2000 products on one page.

 

It may be that your host is slow - mine is quite fast. (See my WWW link below.)

 

The other possibility is that you have something on your pages that loads slowly, such as an off-site banner ad.

I dont know what it could be. Here, you can see for yourself

 

http://www.postersnthings.com/catalog/

Link to comment
Share on other sites

You can start by removing your categories count in admin->configuration->my store->show category counts (set it to false)

 

 

The_Bear

Link to comment
Share on other sites

Your main page and catalog pages opened quite quickly for me, particularly considering there are no images on them. Where I saw a slowdown was on the product info pages: the product image for Cafe at Night (Van Gogh) is 35K -- quite hefty!

 

If all of your product images are in that neighborhood for file size, I would suggest:

 

1) Optimizing your images using Photoshop or another similar graphics application. You should be able to get your main picture size down to around 10K by saving it at low resolution (72ppi) with low quality option.

 

2) Create separate thumbnail images for initial display. You should be able to produce a small thumbnail at around 1-2K using same spec's as above. I believe there are programs available to do the work for you. (Check the contrib's section.)

 

HTH,

 

Terry

Terry Kluytmans

 

Contribs Installed: Purchase Without Account (PWA); Big Images, Product Availability, Description in Product Listing, Graphical Infobox, Header Tags Controller, Login Box, Option Type Feature, plus many layout changes & other mods of my own, like:

 

Add order total to checkout_shipment

Add order total to checkout_payment

Add radio buttons at checkout_shipping (for backorder options, etc.)

Duplicate Table Rate Shipping Module

Better Product Review Flow

 

* If at first you don't succeed, find out if there's a prize for the loser. *

Link to comment
Share on other sites

It seemed reasonably quick to me, though I think listing 150 items on a page (lobby cards) is perhaps asking for trouble.

 

Anything you can do to reduce the number of database queries is good.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...