new index for nodequeue_nodes
dalin - October 19, 2009 - 03:38
| Project: | Nodequeue |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Description
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);
#1
Great 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.
#2
patch included
#3
Awesome. This is committed. Thanks again!
#4
Automatically closed -- issue fixed for 2 weeks with no activity.