Need to speed up my database with indexing.

[Zuncan]

Hi,

 

My store has lately become slower and slower. Today I have about 12000 registred customers and about 11000 orders in my database.

 

I have followed Chemo's optimazations tips, but still I need help in speeding up my site. Chemo's tips is mosly just working on getting the number of queriers down.

 

I suspect that I need to index som tables. I have no knowledge in how to do this. I have been in phpMyAdmin some and doing things but never indexed any tables.

 

I searched the topics and came up with this sql-code that I could run to index som necessery tables.

 

alter table categories add index (sort_order);
alter table customers add index (customers_email_address);
alter table orders add index (customers_id);
alter table products add index (products_model), add index (products_price), add index (products_date_available), add index (manufacturers_id);
alter table products_attributes add index (products_id), add index (options_id);
alter table products_options add index (products_options_name);

 

 

Please, I really need som help in this. Is this a good sql-code to run in phpMyAdmin or is something else recommended?

 

What I have especiallly noticed is that the also_purchased module is slowing down the site. I have also noticed that it takes very long time to load orders.php in admin.

 

Please, any help in how to increase the speed of my site is more than welcome.

 

Best regards / Zuncan

[Zuncan]

Please anyone?

[Zuncan]

I can also say that my osc is not so much changed from the the original. At least not the function of it and its database.

 

So would the above code suit good for indexing the right tables in my database?