10 Jul
2008
10 Jul
'08
2:18 p.m.
Quoting David Timothy Strauss <david@fourkitchens.com>:
----- "Earnie Boyd" <earnie@users.sourceforge.net> wrote:
Especially for the InnoDB engine.
How would index issues particularly affect the InnoDB engine?
Performance and the size of the index file. My reference is for Drupal 5 and I do not know what may have changed for Drupal 6 yet but there are a number of duplicated indexes on some of the tables. A column might be used as the first position in combination with another column to create an index and also be declared an index alone. This becomes a duplicate index and isn't needed. Some tables do not have unique or primary key identifiers a big performance hit. Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/