MySQL database query optimization?

Question

PHP

Now the user has the opportunity to make a selection of data for N days (a lot of data is loaded for 1 day). If, for example, 5 people make such a selection at the same time, then the database will hang.
There is an idea to make a selection for 3 months and save it in the cache (data for the past days do not change), and actually update this cache when the user first loads the data, once a day. And then the search by day will be carried out within this cache, if the data selection matches it.
Is it worth doing such manipulations, or is there a better way?

Answer 1

How many rows are in the table?
What is the selection condition?
How long does one request take?
How many results does the answer contain?
What does explain show?