3 ms·
What's the reason for partitioning into daily tables? Why not add a day column and index it on that column?
by jules 13y ago
What's the reason for partitioning into daily tables? Why not add a day column and index it on that column?
- endianswap 13y agoEasier to move old historical data onto larger, slower drives if it's stored independently.
- RyanZAG 13y agoIndex would become bigger than ram. Removing old data would be more difficult. They likely only use todays data. This is probably a trading data system of some kind.