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
Post a Comment