caching - Searching/selecting query in cache -


i have been using cache long time. store data against key , fetch cache whenever required. know stackoverflow , many other sites heavily rely on cache. question use key-value mechanism caching or form sql query within cache? instance, want view last week report. report's content vary each day. need store different reports against each day (where day key) or can result forming query aggregate result across different key? caching product (like redis) provide functionality?

thanks in advance

cache done key-value hash table. how stays fast. if you're doing querying you're not doing cache.

what may trying ask is... have in database table contains agregated report data. , query against pre-calculated table.


Comments

Popular posts from this blog

asp.net mvc - SSO between MVCForum and Umbraco7 -

Python Tkinter keyboard using bind -

ubuntu - Selenium Node Not Connecting to Hub, Not Opening Port -