how to use cache technology solve complex sql data

manpreet 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?

manpreet 2 years ago