26 Nov
2005
26 Nov
'05
4:36 p.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