sleepycat db VS MySQL or postgres
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