Posted by dalin on October 19, 2009 at 3:38am
| Project: | Nodequeue |
| Version: | 7.x-2.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
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);
Comments
#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.