3 ms·
> "you said 125 characters for that string field and you just received 130, FAIL" Most (all?) RDBMS's have something like a varchar(max) which accepts reasonab
by taco_emoji 9y ago
> "you said 125 characters for that string field and you just received 130, FAIL"
Most (all?) RDBMS's have something like a varchar(max) which accepts reasonably large strings.
> you have to create indexes and fus with all sorts of relational nonsense
No, you don't.
> its going to read the entire table into memory and re-write it back to disk
Probably not, if you're adding a nullable column.
- autokad 9y agoyou obviously have not used databases very much if you think you can join 2 billion row tables on a key that is not indexed in a reasonable amount of time.
- testvox 9y agoSo? It's not like a nosql db without indexes will be any faster at it.
- autokad 9y agoyes, its absolutely faster. try it. Granted a nosql db like hive is 'cheating' by taking advantage of lots of disks/hardware on lots of machines, but i routinely join billion row tables with million row tables and wait only a minute.
- taco_emoji 9y ago> Granted a nosql db like hive is 'cheating' by taking advantage of lots of disks/hardware on lots of machines That's not "cheating", it's literally the only relevant factor. Who would win in a fight: a superintelligent ninja cat with laser nunchucks and body armor, or a dog?
- Clubber 9y agoMy cat beats my dog in fights all the time, and he doesn't have any of that training or gear.
- collyw 9y agoCreating an index in one command is a bonus of using SQL databases. Messing around creating yet another database seems to be the equivalent on NoSQL.