Re:Ask HN: What database should I use for analytics data?
by AdriaanvRossum on Sunday November 03, 2019 @05:46AM
(#21433153)
I think I can still optimize the extra generated data. And I think you're right about the 2 weeks being to limited. I will optimize my processing scripts (those are the culprit now)
The queries sound like something that should be aggregated over time once and saved so you don't have to do any non-trivial query from the dashboard.
If you're actually pushing limits on the current database, then I don't think 2 weeks will be enough to get familiar enough with operations and failure modes of a new one.