Post by stf » Tue May 15, 2012 4:07 am

So ... after my host sent me a notice that I am using too many resources and told me to optimize my SQL database or they`ll suspend my account I found that a good way to do it is to run ALTER TABLE ADD INDEX ...

My question is for which tables and their columns should I ADD INDEX ?

I found an older post where uksitebuilder recommends some SQL queries .

The thread is one year old and I`m not sure what changed.

I am using OC version with shoppica theme.

I also installed a couple of mods that added tables in my database. should I add index to those too ? (i guess it depends on what they do but you guys dont know :) )

Hope I made sense :)

Thank you!

New member


Mon Apr 02, 2012 4:10 pm

Post by JAY6390 » Tue May 15, 2012 4:22 am

All of those queries should work and increase performance yes


User avatar
Guru Member


Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by Tcalp » Tue May 15, 2012 5:32 am

STF ... If you need any help feel free to grab me on skype, I can have a look and suggest things if you'd like (no charge). My skype id is:

Increase Page Speed (#1 rated commercial extension on OpenCart Marketplace)
15in1 Essential Extensions Value Pack Premium Customer Testimonials Reward Points Extended Admin Security Lockdown Suite

Image #opencart

User avatar
Active Member


Wed Jul 06, 2011 1:49 pm

Post by tarang1906 » Fri Jun 22, 2012 11:31 pm

Hi Tcalp,

I really need to optimize my database.

Could you please guide me in the right direction?



Wed Mar 07, 2012 9:41 pm
Who is online

Users browsing this forum: No registered users and 59 guests