|
Posted by Anze on 12/15/05 20:02
> The problem is your like clause, because you use leading % mysql isn't
> able to use an index for it. To speed this up you could try to use the
> fulltext functions and the fulltext index of mysql but that isn't sure to
> help you.
Right to the point. :)
Hmmm, that might help - FULLTEXT search on a search table... ;)
I'll try this just to see if it is any faster than "LIKE '%abc%'".
Thank you!
Anze
Navigation:
[Reply to this message]
|