I am having the same kind of difficulty. Slow returns on results.
It may be bad database architecture or implementation (perhaps both),
but I need to be able to pick out text fragments . . . like %value%.
I understand that indexes do not help with "LIKE %value%" queries, is
there anything else that I can do to speed up the return on results.
Thanks,
Brett
>Osus writes:
>> Hi,
>> SELECT * FROM table WHERE OK=1
>> it gets about 4 or 5 second at least.
>> I have indexes. That main table have 27 indexes to supply all
>>possible searches.
>> Some searches are made on text fileds, something like "WHERE field
>>like '%key%' being field text field.
>>
>> I have updated mysql and apache, checked, repaired, optimized
>>tables. I run fschk on all the partitions.
>>
>> What can I do? I need to reduce that times...
>>
>>
>> Thanks
>
>Having 27 indexes and using queries with LIKE "%...%" is a nice
>recepee for slowness.
>
>Try normalising your schema and using fulltext search instead of LIKE
>"%...%". "%..%" queries can't use indices.
>
>--
>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
--
---------------------------------------------------------------------
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