The other day in the boost module worked around a bug in view by running the query manually #797496: Manipulating view filters in code. $view->result has different results from db_query of $view->build_info. Taking this same approach I can run explain on every query views can output.

Comments

mikeytown2’s picture

mikeytown2 commented
Title: Run explain on every query » Run explain on every views query

Have different fieldgroups for each level of uglyness. filesorts, where, etc...

mikeytown2’s picture

mikeytown2 commented
Status: Active » Needs work

committed phase 1 of this
http://drupal.org/cvs?commit=367288

mikeytown2’s picture

mikeytown2 commented

helpful post
http://www.kpbowler.co.uk/perfect-tables-in-drupal