In the last episode (Jan 16), mos said:
> 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?
SQL_NO_CACHE doesn't affect mysql's key cache or the OS's buffer cache.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
