Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Just an idea for if you want to get real fancy.
Lets say a view has a filter on one or more fields and is sorted on one or more fields, if all of these fields are in the same table a composite index would be in order:
filter 1, filter 2, ..., filter N, sort 1, sort 2, ..., sort N.
(If the fields are in different tables you're screwed and MySQL has to create a temp table anyway)
Comments
Comment #1
mikeytown2 CreditAttribution: mikeytown2 commented