3 ms·
From ~8 seconds to ~3 seconds to fetch 5,000 items seems like going from horrible to still really actually pretty bad. Just about any SQL server with well defi
by donatj 3y ago
From ~8 seconds to ~3 seconds to fetch 5,000 items seems like going from horrible to still really actually pretty bad.
Just about any SQL server with well defined schema and indexes would blow this out of the water by several orders of magnitude.
Schemaless in this old devs opinion is basically always a bad idea. Your data has a schema, whether or not you wish to define it. In not bothering to do so though you’re not doing yourself many favors.
- maxerickson 3y agoThe upside is that it is like AirTable, except you have to stand up a server with a custom service if your logic or computation doesn't fit into their no code tooling.
- deleted 3y ago[deleted]
- sgarland 3y agoYou’re correct on all points, but at some point you begin to hit practical limits on things like maximum tables per DB. You could shard of course, but then you have to handle that, as well as failover, data locality, etc.