I'm on WinXP, 2.6ghz. mysqld-nt Alpha 4.1.2
Either way, I was surprised to see the "like" to be in the top
performers and "left()" to be last.
Ed
---------------------------
* ed aka emierzwa at micron.com
> You could just use the benchmark function?
>
> select BENCHMARK(10000000, 'dfsfsdfs' like 'F%' ) /* 0.45 sec. */
> select BENCHMARK(10000000, 'dfsfsdfs' between 'F' and 'Fzzz' ) /* 0.55
> sec. */
> select BENCHMARK(10000000, left('dfsfsdfs',1)='F' ) /* 0.79 sec. */
I get a different result. On my (slow) computer, the BETWEEN operator is
the
fastest:
mysql> select BENCHMARK(10000000, 'dfsfsdfs' like 'F%' );
1 row in set (2.17 sec)
mysql> select BENCHMARK(10000000, 'dfsfsdfs' between 'F' and 'Fzzz' );
1 row in set (2.06 sec)
mysql> select BENCHMARK(10000000, left('dfsfsdfs',1)='F' );
1 row in set (2.68 sec)
mysql> select BENCHMARK(10000000, 'dfsfsdfs' >= 'F' and 'dfsfsdfs' <
'Fzzz' );
1 row in set (2.13 sec)
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
