mos wrote:
I tried :
select SQL_NO_CACHE * from table where col1='abc';
which took 800ms the first time it was executed. The second time it was
executed it took 0ms. How is that possible if the query is not put into
the query cache? Should the query take roughly the same amount of time?
Disk cache.
The database table was still in memory.
The OS caches a lot of stuff too (file descriptors etc).
Try restarting mysql between runs and see if that's more consistent.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
