Benchmark()

[Raimundo Sierra]

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]