* ed aka emierzwa at micron.com > I'm on WinXP, 2.6ghz. mysqld-nt Alpha 4.1.2
w2k, 0.6ghz, 3.23.30-gamma > Either way, I was surprised to see the "like" to be in the top > performers and "left()" to be last. I suppose the LIKE operator is optimized for the case when it begins with a constant: mysql> select BENCHMARK(10000000, 'dfsfsdfs' like '%F%' ); 1 row in set (3.43 sec) This statement of course performs a different operation compared to the other examples, but it shows the LIKE operator is relatively slow when the expression starts with "%". -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
