I’ve built a reporting application that is really simple - you can create tables with 1 or 2 X & Y axis and filter on values (name = A, age = B)
The data that the reports look at is almost always filtered by date (e.g. looking at the last week, month, etc)
Currently the data is stored in a Oracle database and SQL is used to select, group and filter.
I don’t need or use the full power of a SQL database, I only use sum, max and min.
Would ROOT make my application quicker?
Ideally I would love to store the data indexed by every column that can be used as an axis to allow all filtering to be as quick as possible. Storage space is not an issue.