Hey,

I spent some time debugging the mysql keys on my site and it is currently a critical issue for me keeping me from implementing this module. I would appreciate any help.

In your documentation you give the example of the top terms view:
http://drupal.org/node/389230

The resulting query is using filesort and this is quite a problem on large sites with many nodes.

I tried reducing it, to figure out where I could add an index, but I am quite lost:

EXPLAIN SELECT  term_data.tid AS term_data_tid
FROM node node
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
GROUP BY term_data_tid

Comments

irakli’s picture

irakli commented
Category: bug » support

This is not a bug, since neither Views nor, and even less, views_groupby are responsible for making sure tables have proper indexes.

This is a support ticket.

rsevero’s picture

rsevero commented
Assigned: Unassigned » rsevero
Status: Active » Fixed

I bet the main problem is the use of LEFT JOIN, not the lack of any INDEXs.

Please reopen at the right Project issue queue (Views?) if necessary.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.