Optimizing Drupal Views: Query Time and Rendering Time
A recent client performance assessment consulting project showed that on their site, the main page that logged in users would browse is slow. Tuning the server for memory and disk throughput helped somewhat, but did not fully eliminate the issue.
Looking at the page, it was a view, and the total time was around 2.75 seconds.
The main query was not efficient, with lots of left joins, and lots of filtering criteria: