3 ms·
If you have fewer than ten thousand simultaneous users, this is not you. After ten million, you're not using an ORM in front of a bare relational database eithe
by ttfkam 3y ago
If you have fewer than ten thousand simultaneous users, this is not you. After ten million, you're not using an ORM in front of a bare relational database either.
Scale at high numbers adheres to no rules or off-the-shelf tools.
- Pxtl 3y agoI wish. I'm constantly having to reinvent materialized views on engines that don't have good support for the concept (ms SQL, sqlite) because my users want to sort/filter on a calculated column, meaning that I have to revert to "dumb bucket of bits" for records in seven figures and user-counts in the dozens. Relational algebra is good. I like the idea of nornalized data. I hope to be able to use it one day instead of SQL.
- ttfkam 3y agoSo… use one of the engines with better support for materialized views? This sentiment is like saying, "Java doesn't support traits, so I hate all programming languages." If an engine doesn't support a feature you need, use a different engine. If your workplace does not allow this, that's an issue you have with your workplace, not the tools.