| 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? | mos | 16 Jan |
| • Re: Does SQL_NO_CACHE work? | Chris | 16 Jan |
| • Re: Does SQL_NO_CACHE work? | Dan Nelson | 16 Jan |
| • Re: Does SQL_NO_CACHE work? | Moon's Father | 16 Jan |
