Optimizing: Can I add MySQL Indexes?
MissyM - March 27, 2008 - 17:55
I've noticed some of my queries take too long. Can I just add indexes to my databases? Does anyone know of any negative consequences of that? The particular issue I'm having is a CCK node reference field type. It sorts through the entire table rather than just plucking out the node reference I'm after.
Thanks in advance for help and/or comments.
Missy
The only negative
The only negative consequence is going to be that indexes use up a bit of disk space.
I've found that some Drupal modules don't add good indexes. Add, experiment, and then file an issue with the module maintainers if you find a useful index.