sleepycat db VS MySQL or postgres

Mark Felder feld at feld.me
Tue Jul 2 12:18:03 UTC 2013


On Tue, 02 Jul 2013 07:12:37 -0500, Ivan Voras <ivoras at freebsd.org> wrote:

> 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.
>

Good point :) I'm still sure it would work much, much better though.  
However, I'm just glad that's not *my* problem to fix.


More information about the freebsd-questions mailing list