sleepycat db VS MySQL or postgres

[Ivan Voras]

On 02/07/2013 13:55, Mark Felder wrote:

> If twitter was built upon a WORM database instead of MySQL they could
> host the entirety of twitter on a handful of servers instead of the
> gross MySQL+Cassandra mess they're fighting with today.

I'd say their problem is not exactly solvable by only choosing a database :D
They, like Facebook, have the problem of "fanout", where a single piece
of data goes into thousands of different user pages. Whatever they save
in the raw data access operations will probably be relatively small
compared to the horsepower needed to combine pages from all these
fleeting data pieces.

But yes, obviously a database designed specifically for one thing will
be optimized for that thing.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 261 bytes
Desc: OpenPGP digital signature
URL: <http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20130702/e50abc85/attachment.sig>