I really wish I could do something like that for our system. We need to hit the database almost every time a query comes in.
http://i.imgur.com/Q8NtKTk.png
Cache hits versus misses. The latter may result in multiple SQL queries whereas the former are returned from the cache. Imagine the cluster we'd need to support that!
That's over 28 days for reference.
That isn't the same as we couldn't get some benefit, because we could especially as the userbase scales. But so far we haven't had to scale to the point where it's worth the added complexity to persuit. One can only look forward to the day it is.