4 ms·
Seems impractical and slow at scale to manage even a few hundred separate databases. You lose all the advantages of the relational model — asking simple questio
by gregjor 6y ago
Seems impractical and slow at scale to manage even a few hundred separate databases. You lose all the advantages of the relational model — asking simple questions like “Which customers ordered more than $100 last month” require more application code. You might as well store the customer info in separate files on disk, each with a different possible format and version.
- vyrotek 6y agoThose queries are definitely convenient early on but eventually you shouldn't be making those against that system and instead aggregate the data into warehouse. Technically, there are DBs that let you do cross shard queries. See Azure Elastic DB.