Carsten H. Pedersen writes:
>
> ...
>
> > Having 27 indexes and using queries with LIKE "%...%" is a nice
> > recepee for slowness.
>
> Why should having 27 indexes slow down a SELECT?
>
> / Carsten
> --
> Carsten H. Pedersen
> keeper and maintainer of the bitbybit.dk MySQL FAQ
> http://www.bitbybit.dk/mysqlfaq
It would slow down directly all commands that change tables.
Indirectly it will slow down SELECT's as key buffer would not be used
effectively.
Also, as all 27 indices are in the same .MYI file, blocks from the
same index will definitely be very fragmented.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
