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 different than the first one for MySQL's query cacher. Is MySQL able to determine smaller subsets of a larger result set in terms of a query cache? I'm not sure if this is by design or a feature not yet implemented? Thanks, Mukul -- Mukul Sabharwal http://mjsabby.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
