From owner-freebsd-questions@FreeBSD.ORG Tue Jul 2 12:12:49 2013 Return-Path: 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 4CB4284D for ; Tue, 2 Jul 2013 12:12:49 +0000 (UTC) (envelope-from freebsd-questions@m.gmane.org) Received: from plane.gmane.org (plane.gmane.org [80.91.229.3]) by mx1.freebsd.org (Postfix) with ESMTP id 0BADE1937 for ; Tue, 2 Jul 2013 12:12:48 +0000 (UTC) Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1UtzRv-0007Yg-Si for freebsd-questions@freebsd.org; Tue, 02 Jul 2013 14:12:47 +0200 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 02 Jul 2013 14:12:47 +0200 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 02 Jul 2013 14:12:47 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-questions@freebsd.org From: Ivan Voras Subject: Re: sleepycat db VS MySQL or postgres Date: Tue, 02 Jul 2013 14:12:37 +0200 Lines: 38 Message-ID: References: <51D1E68B.5050508@paz.bz> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="----enig2RNDVDTSCXTTRRNDUHTCL" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:17.0) Gecko/20130322 Thunderbird/17.0.4 In-Reply-To: X-Enigmail-Version: 1.5.1 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Jul 2013 12:12:49 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) ------enig2RNDVDTSCXTTRRNDUHTCL Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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. ------enig2RNDVDTSCXTTRRNDUHTCL Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (FreeBSD) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iEYEARECAAYFAlHSw7UACgkQ/QjVBj3/HSyJOQCeImoBwY1LjVQJfHQ3ZunjmrUz Yj8An3/voTd7GfydT4TEjpI7bLpzn3jw =JacS -----END PGP SIGNATURE----- ------enig2RNDVDTSCXTTRRNDUHTCL--