Slowness solutions

[eturi]

My DB is quite large and load times is being increasing, have anyone some solutions for this ?

[julianpuje]

I used this that was posted earlier, sorry, i can't remember who by.

 

 

Following the order presented, in PHPMyAdmin select your database and:

 

1. Click the SQL tab and enter the following in the textbox and click enter:

 

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);

 

 

2. Click the Structure tab and under the table listing click Check All and select Optimize from the drop down.

 

This optimizes the database.

Also make sure you have gzip compression enabled in your admin area.

I also used the config cache and thumbs GD library contributions.

My site has come down from @ 50sec @ 56k to 8.3 sec.

 

I hope this helps

 

Julian :D

[Guest]

Sounded good, don't have optimize in my drop down tho.

Are you supposed to sql each individually or as a set?

Thanks

Rolf

[Daemonj]

Copy and paste the entire sql block and you should be good. :)

[oscommercenewbie]

Tied this and received the following error message.

 

 

Error

 

SQL-query :

 

ALTER TABLE products ADD INDEX ( products_model ) ,

ADD INDEX ( products_price ) ,

ADD INDEX ( products_date_available ) ,

ADD INDEX ( manufacturers_id )

 

MySQL said:

 

 

#1069 - Too many keys specified. Max 32 keys allowed

 

 

Anyone know what this means?