Little, Timothy wrote:
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 :
flush tables;
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?
Tim...
Disk cache, but I don't know how to clear it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org