Database Indexes Mod

[ombre +]

Hi,

index on a database table should produce quick answers on sql queries. I have monitored the mysql database and found that on few tables the indexes
don't exists. So i added the indexes. Here is the code:

create index pid_index on class_prodimages (pid);
create index pid_index on class_favorites (pid);
create index state_index on class_users (state);
create index city_index on class_users (city);
create index slug_index on class_categories (slug);
create index name_index on class_categories (name);
create index parentid_index on class_categories (parent_id);
create index section_index on class_listings (section);
create index expiration_index on class_listings (expiration);
create index display_index on class_listings (display);

What other members think about this, and do you have also improved the sql queries ? Please share your experience. Thanks.

[Eric Barnes]

Thanks for sharing. I will be sure these are added to v4.1