Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Speeding up the database


Guest

Recommended Posts

I am wondering whether there is a way of speeding up queries. I have a store with over 80,000 items and the query by manufacturer and category takes alittle while to load. It takes almost a minute to load. I dont think its a server issue, its probably the amount of data thats being queried.

 

Any ideas on how to speed it up or maybe alter the queries to make them more efficient or less time consuming?

 

Any ideas will be appreciated.

 

:thumbsup: :thumbsup:

Link to comment
Share on other sites

In your Admin

disable catagory counts (worst offender for DB queries)

enable gzip compression

only use SSL for checkout not the full site

With phpmyadmin optimize/repair/check the database yourself to get you started

 

contributions that may help:-

 

DB auto optimizing

thumbs with gd library (image contri for large images)

configuration cache

page cache

 

 

 

HTH

 

Julian

A little knowledge is dangerous, I SHOULD KNOW.

If Life Begins At 40, What ends????

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...