If the related query is very close, it may be wrong to choose redis. It is more suitable to choose a product that supports conditional query, such as MongoDB;
If it is not very close, query ABC separately to determine which table can get the smallest result set through the conditional filtering after where; then use this minimum result set to check the other two tables;
In addition, redis supports intersection, but the time complexity is relatively high, and it may not be faster than filtering it yourself; http://redisdoc.com/set/sinter.html
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
If the related query is very close, it may be wrong to choose redis. It is more suitable to choose a product that supports conditional query, such as MongoDB;
If it is not very close, query ABC separately to determine which table can get the smallest result set through the conditional filtering after where; then use this minimum result set to check the other two tables;
In addition, redis supports intersection, but the time complexity is relatively high, and it may not be faster than filtering it yourself;
http://redisdoc.com/set/sinter.html
Can you use Map table storage?