|How to store fast-changing data in MySQL?
|Page 1 of 1|
|Author:||EleanorW [ Wed Jun 02, 2021 8:29 am ]|
|Post subject:||How to store fast-changing data in MySQL?|
I want to store a date/time and total asset price (adding all stock holdings together) in MySQL for graphing purposes. I want to store data every five minutes when the market is open to show a 1-day chart, and the last traded price for all 1 week, 1 month, 3 months, and 1 year. However, I am confused about how I should design tables for it. Here are some of my ideas:
Make two tables for each user. One for 1-day chart data, and the other for the rest chart data. However, the 1-day chart should be able to be of deque structure since I just want 24-hour data, so adding new data should delete the oldest data.
I should just make one table with two diff columns, one for 1D chart data, and the other for the rest. The goal is to serialize data and store it, which I believe is not an ideal way to go.
Any pointers would be helpful.
|Author:||N_Harris [ Thu Jun 03, 2021 5:07 am ]|
|Post subject:||Re: How to store fast-changing data in MySQL?|
Assuming that I understood you correctly, you need advise for application development (or in this case the database structure) - this thread in stackoverflow.com might be a useful starting reference: https://stackoverflow.com/questions/125 ... nformation
|Page 1 of 1||All times are UTC|
|Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group