3 ms·
> didn't fully understand it and what it was good for This is why I'm not a fan, its "sweet spot" , in my experience, is not very big and not very interesting.
by dcosson 12y ago
> didn't fully understand it and what it was good for
This is why I'm not a fan, its "sweet spot" , in my experience, is not very big and not very interesting. It requires a small data set where at least the indexes (but ideally the entire "working set") fits in memory on a single server, in which case it can get pretty good read throughput. But there are a lot of options that perform great in this use case, including just mysql or postgres. Maybe the flexibility of being schema-less is a win for some people, in which case great, I'm glad it's available as an option.
But when the company claims things like it's the best database for every use case, people are bound to use it wrong, get burned, and then hate it. Where I used it it had been the exact wrong choice to make, a data set bigger than ~2x a single server's memory (and growing) and with relatively high write throughput, and it was an absolute nightmare.