I’m working on an app that allows users to create custom tables from lists that they make.
The problem is:
- We want to support thousands of users.
- Each user will have dozens of tables.
- Each table will have thousands of rows.
We could end up with hundreds of millions of things, approaching a billion, in a single data type, which would be incredibly slow.
The thing is, it would actually be pretty fast if we could create a unique data type for each table that the user creates.
Is it possible? Or is there some way to increase efficiency for large data sets where certain defined subsets are known will always be interacted with the same way?