Combination use of MySQL and redis cache

Question

Guys, I want to ask a question. I now have a statistical need to count the consumption of users in the store in the current month, 3 months and 6 months this year; then I plan to first use MySQL to collect the consumption of the store users. The order records are checked once and then put into Redis. If you query again on the same day, you will check Redis, and you also need to perform filtering and statistics

Answer 1

It mainly depends on how you design your *** table. If all your information is in one table, there is definitely no way to achieve it.

Answer 2

Yes, you can use redis or memcache