From owner-freebsd-questions@FreeBSD.ORG  Tue Jul  2 12:18:03 2013
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by hub.freebsd.org (Postfix) with ESMTP id CB93394E
 for <freebsd-questions@freebsd.org>; Tue,  2 Jul 2013 12:18:03 +0000 (UTC)
 (envelope-from feld@feld.me)
Received: from out1-smtp.messagingengine.com (out1-smtp.messagingengine.com
 [66.111.4.25]) by mx1.freebsd.org (Postfix) with ESMTP id 9EC8E197D
 for <freebsd-questions@freebsd.org>; Tue,  2 Jul 2013 12:18:03 +0000 (UTC)
Received: from compute2.internal (compute2.nyi.mail.srv.osa [10.202.2.42])
 by gateway1.nyi.mail.srv.osa (Postfix) with ESMTP id 856BD209B1
 for <freebsd-questions@freebsd.org>; Tue,  2 Jul 2013 08:18:02 -0400 (EDT)
Received: from frontend2.nyi.mail.srv.osa ([10.202.2.161])
 by compute2.internal (MEProxy); Tue, 02 Jul 2013 08:18:02 -0400
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=feld.me; h=
 content-type:to:subject:references:date:mime-version
 :content-transfer-encoding:from:message-id:in-reply-to; s=
 mesmtp; bh=WqN0XSXnLuemobcU0blnWb2jYZk=; b=kfRpN7nwDvtFwjox+yI02
 IAMfQNQoTeMRKOqtOHBENHSvbEVANRVlAVe8cBm4gLHdeEK7Sk2wJHJYjh37eH2r
 FrwbaqUIYtGfqzePjKzzGqVcrsv6ebHOxumWaCvPM7FIEBt1aDJ+JK8kDvIqYEAl
 QJpp9yMKMpf5/wkI0V2gSY=
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=
 messagingengine.com; h=content-type:to:subject:references:date
 :mime-version:content-transfer-encoding:from:message-id
 :in-reply-to; s=smtpout; bh=WqN0XSXnLuemobcU0blnWb2jYZk=; b=G3hd
 GnzgMkYli7e32qxhVSk1b6N9ZHIJyazYo4FQEWimCZhUcUFokbBESGAAAD53upDF
 UHHJfQqOmC/I38fSnGqruBM4XlEiewp15VqEKSslttF13gNhhyOUt2z82nbCiPRl
 GfVgWfsxT5RpvkRf0o7YzF/QnadO1LrEWW9+2XU=
X-Sasl-enc: VPD/XIJdLK+1BMIQIZCHAkL9eXcLki5fpdpop+rHxfei 1372767482
Received: from tech304.office.supranet.net (unknown [66.170.8.18])
 by mail.messagingengine.com (Postfix) with ESMTPA id 1E54A6804BC
 for <freebsd-questions@freebsd.org>; Tue,  2 Jul 2013 08:18:02 -0400 (EDT)
Content-Type: text/plain; charset=us-ascii; format=flowed; delsp=yes
To: freebsd-questions@freebsd.org
Subject: Re: sleepycat db VS MySQL or postgres
References: <51D1E68B.5050508@paz.bz> <kqub0l$8pk$1@ger.gmane.org>
 <op.wzlfe12e34t2sn@tech304.office.supranet.net> <kqug3f$5j3$1@ger.gmane.org>
Date: Tue, 02 Jul 2013 07:18:01 -0500
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: "Mark Felder" <feld@feld.me>
Message-ID: <op.wzlggbj834t2sn@tech304.office.supranet.net>
In-Reply-To: <kqug3f$5j3$1@ger.gmane.org>
User-Agent: Opera Mail/12.15 (FreeBSD)
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 02 Jul 2013 12:18:03 -0000

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.