General Tech Technology & Software 2 years ago
Posted on 16 Aug 2022, this text provides information on Technology & Software related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.
As you indicate, there is a mismatch between a relational database and a key-value store (or cache).
The usual way to overcome the mismatch is to de-normalize your data. That is cache specific results which can then be retrieved with a single key lookup.
So, from your example, you would cache the result of the select AND the filter in one cache key-value.
Of course, doing this on data that is written then raises the problem of consistency.
Welcome to the fun!
No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
General Tech 10 Answers
General Tech 7 Answers
General Tech 3 Answers
General Tech 9 Answers
manpreet![Tuteehub forum best answer]()
Best Answer
2 years ago
i have some common sql,and frequent use the result of sql,and add some other condition to select.i need to cache the result. i try to put sql result in redis,but the key cannot adopt the requirement,i don't recognize sql relation through key. table
for example i want to put the order table which all type = 2 put in cache,and then i use the result filter all department_id =4. the key redis cannot fill it. this example is simple,in requirement,it can be complex sql with some table join result. what cache technology can solve this problem?