Hello.
In your query BENCHMARK() doesn't execute the query, it is passed just like a string to the second argument of the BENCHMARK(). Raimundo Sierra wrote: > 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) > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
