'How to handle high frequency intraday table and then store data?
I am relatively new to SQL, and I am currently designing a DB for a project. In this project, there are high-frequency queries intraday but the queries for past days occur at lower frequencies. To decrease the response time for high-frequency queries, the approach I thought about was to create two separate tables, one for intraday and the second one as an archive. At the end of each day, I would copy all the data from the intraday table to the archive table.
Is there a better or standard approach for this task? I have been searching about this and I feel that I don't know the exact term to search for.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|