DB Optimisation Suggestions

Hi

I’ve been looking at further optimisation of the EE database indexes and have a few suggestions after analysing the SQL debug output which you may want to put into a later release:

• exp_categories.parent_id : often used in joins and where clauses
• exp_channel_titles.sticky : regularly used in order by clause
• exp_channel.channel_name : used in where clause
• exp_relationships.rel_type : used in where clause
• exp_channel_entries_autosave.original_entry_id : used in where clause (delete statement)

I noticed about a 10-20% improvement (on average) after adding the above.

Cheers

Tim EEvolution.co.uk