Re: Query result cache not getting inserted for query lasting > 5secs

2016-03-10 Thread Erick Erickson
Let's see the query. If you do anything with dates using NOW (without rounding), the queries are actually not the same since NOW resolves itself to the epoch and will change every millisecond. Best, Erick On Thu, Mar 10, 2016 at 12:18 AM, Murali TV wrote: > Hi, > > I have a query that takes abou

Query result cache not getting inserted for query lasting > 5secs

2016-03-10 Thread Murali TV
Hi, I have a query that takes about 5secs to complete. The result count is about 250 million, and row size is about 25. The problem is that this query result is not getting loaded to the query cache, so it takes ~5secs every time its issued. I also confirmed this by looking at the cache stats pag