Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.There were several queries coming up in my slow query log because MySQL could not utilize any of the existing indexes on this table. Adding the following index helped:
ALTER TABLE {nodequeue_nodes} ADD INDEX {nodequeue_nodes}_qid_nid_idx (qid, nid);
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | nodequeue_nodes_idx.diff | 788 bytes | dalin |
Comments
Comment #1
ezra-g commentedGreat suggestion, thanks. If you could put this into a patch to be part of the default schema and update for current users as an implementation of hook_update_N I would commit it. Otherwise, I'll do this when I'm able to. Would love to get this into the next release.
Comment #2
dalinpatch included
Comment #3
ezra-g commentedAwesome. This is committed. Thanks again!