Don’t Fight the Query Cache

It is easy to overlook certain “non-deterministic” functions in your queries which will prevent the query cache from caching its results. Many cases, particularly date/time related queries, can actually benefit from the cache, and there is a simple workaround.