In trying to improve the performance of an ExpressionEngine-powered web-based system, I came across the following database fields within MySQL query WHERE clauses that therefore should be indexed but aren’t:
* exp_actions: class, method
* exp_categories: cat_url_title
* exp_ce_cache_tagged_items: item_id
* exp_channels: channel_title
* exp_channel_fields: field_name
* exp_extensions: enabled, hook, priority
* exp_fieldtypes: name
* exp_members: in_authorlist, screen_name, username
* exp_menu_items: sort
* exp_modules: module_name
* exp_playa_relationships: parent_is_draft
* exp_plugins: is_typography_related
Every little bit helps.
