For example, I'm not entirely sure, what the implications of using
LIKE on large datasets is? I suppose, that in theory, LIKE should be
able to perform reasonably well, since the match is anchored, but I'm
not sure how well MySql (We use MySql) works.
I'm not a real MySQL guru either, but I could run some benchmarks on
this next week I suppose. If you have a more specific question about
the cost of an operation, I'd be happy to explain you the algorithm.
Using the 'like' operator has usually the same cost as using an equality
operator, regardless of db, so there is no huge speed penalty involved,
if any at all.
Otoh index selectivity plays a big role in performance: the more rows
(children) a select fetches, the more it will be slower compared to a
select done on eg. the pk (note: this is all unscientific evidence,
gathered from tests on ezpublish installations done with mysql).
bye
Gaetano
--
Components mailing list
[email protected]
http://lists.ez.no/mailman/listinfo/components
