Also titled, I want this to run slow ALL the time...
I have a group of dreadful queries that I have to optimize.
Some take 20-30 seconds each -- the first time that I run them. But
then they never seem to take that long after the first time (taking less
than a second then). If I change the "keywords" searched for in the
where clauses, then they take a long time again... so it's the
query-cache or something just like it.
BUT, I am doing this each time :
reset query cache;
set global query_cache_size=0;
SELECT SQL_NO_CACHE DISTINCT ca.conceptid AS headingid,
And still it's not avoiding the cache.
Is there a cache I'm missing?