[development] Drupal could be 10x times faster with correct indexing

[Nathaniel Catchpole]

There were several patches in Drupal 6 which removed duplicate indexes
(and/or added missing ones), so it's likely that pretty much all of these
issues are resolved.

Nat

On Thu, Jul 10, 2008 at 1:18 PM, Earnie Boyd
>
>
>
>
>>
> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20080710/891e06e3/attachment.htm