Re: query_cache and LIMIT

2007-07-12 Thread mos
At 04:26 PM 7/12/2007, Mukul Sabharwal wrote: Hello, Is the query_cache a cache for *exact* queries -- exactness here refers to as determined by the query plan. Or is it word for word? It is word for word, and is case sensitive. Query in question, SELECT * FROM tbl WHERE ... LIMIT 100; as o

query_cache and LIMIT

2007-07-12 Thread Mukul Sabharwal
Hello, Is the query_cache a cache for *exact* queries -- exactness here refers to as determined by the query plan. Or is it word for word? Query in question, SELECT * FROM tbl WHERE ... LIMIT 100; as opposed to SELECT * FROM tbl WHERE ... LIMIT 10 Apparently, it seems that the second query is d