Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 02 Jul 2013 07:18:01 -0500
From:      "Mark Felder" <feld@feld.me>
To:        freebsd-questions@freebsd.org
Subject:   Re: sleepycat db VS MySQL or postgres
Message-ID:  <op.wzlggbj834t2sn@tech304.office.supranet.net>
In-Reply-To: <kqug3f$5j3$1@ger.gmane.org>
References:  <51D1E68B.5050508@paz.bz> <kqub0l$8pk$1@ger.gmane.org> <op.wzlfe12e34t2sn@tech304.office.supranet.net> <kqug3f$5j3$1@ger.gmane.org>

next in thread | previous in thread | raw e-mail | index | archive | help
On Tue, 02 Jul 2013 07:12:37 -0500, Ivan Voras <ivoras@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.



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?op.wzlggbj834t2sn>