List:General Discussion« Previous MessageNext Message »
From:mos Date:January 16 2008 6:19am
Subject:Does SQL_NO_CACHE work?
View as plain text  
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?

TIA
Mike
MySQL 5.0.24
Thread
Does SQL_NO_CACHE work?mos16 Jan
  • Re: Does SQL_NO_CACHE work?Chris16 Jan
  • Re: Does SQL_NO_CACHE work?Dan Nelson16 Jan
    • Re: Does SQL_NO_CACHE work?Moon's Father16 Jan