It is not clear to me what benchmark really does. Example:
SELECT SQL_NO_CACHE * FROM mytable where myVarcharRow like 'sometext%' or otherVarcharRow like 'someothertext';
takes approx. 0.3 seconds. If you benchmark this query, which to my understanding should run and not just parse the query, it is faster??
SELECT BENCHMARK(10000000, "SELECT SQL_NO_CACHE * FROM mytable where myVarcharRow like 'sometext %' or otherVarcharRow like 'othertext %'");
returns 1 row in set (0.12 sec) Another similar example is: SELECT * FROM Table; returns: 59770 rows in set (0.23 sec) SELECT BENCHMARK(100000, "SELECT * FROM Table"); returns: 1 row in set (0.01 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]