26 Nov
2005
26 Nov
'05
10:36 a.m.
Hi Juha,
Am Samstag, den 26.11.2005, 17:17 +0200 schrieb Juha Heinanen:
are you saying that LIKE operation is much slower that a many exact matches? if so, it looks like a bug in mysql's LIKE implementation. have you asked mysql list, why LIKE takes so long?
It definetly is. Try generating a million entries and use the MySQL command line interface to measure the time for the operation. A like operation takes about one second, a exact match (if there is an index for that column) less than 10 ms.
As far as I know the LIKE operation cannot make use of an table index and thus is a lot slower. And no, I haven't contacted the mysql list, since I'm not that surprised by that fact.
Regards, Stefan