Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Speeding up the database


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







A little knowledge is dangerous, I SHOULD KNOW.

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

Link to comment
Share on other sites


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

  • Create New...