From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: <jgarzik@gmail.com> Received: from smtp1.linuxfoundation.org (smtp1.linux-foundation.org [172.17.192.35]) by mail.linuxfoundation.org (Postfix) with ESMTPS id 9B3063EE for <bitcoin-dev@lists.linuxfoundation.org>; Wed, 28 Oct 2015 21:11:49 +0000 (UTC) X-Greylist: whitelisted by SQLgrey-1.7.6 Received: from mail-wi0-f181.google.com (mail-wi0-f181.google.com [209.85.212.181]) by smtp1.linuxfoundation.org (Postfix) with ESMTPS id 993A0157 for <bitcoin-dev@lists.linuxfoundation.org>; Wed, 28 Oct 2015 21:11:48 +0000 (UTC) Received: by wicll6 with SMTP id ll6so212445798wic.0 for <bitcoin-dev@lists.linuxfoundation.org>; Wed, 28 Oct 2015 14:11:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=ljE//ilyMs7J7Mru6voZBDz7HeaOrjoP+KeQG1ja+rM=; b=0f5E5H2261yTnkdCr8lOwqmmAd+ppV+kKyVXrWHT34to2Mu3st/Xy4uHI+83onWeWF 6qB5SaRSB+uiDeEh3Y0N8kTlRUaH2vWbVf3Z3b55Ev9cHW/7kbCeMu/D1fSj6jdbt8Zz 7vJkg4ynoRQcO4oHYYhdhiWmY8Z0rfwI+ehYim8u4omLlUYcnGXhuhaD150Y29ukGkcc wimeqwDEvrhiqE4jIasu7MShjWn17D0NwKKOrJMDQGSnWBRU98SY10o026QnKBI0cCL4 dUoo0s03LJppnOU/uQtZaCxN28nghtXHAKjfdUGGu4qrW+04JYZ1GRkAT4pIKat3up2M Eutg== MIME-Version: 1.0 X-Received: by 10.28.88.135 with SMTP id m129mr2870347wmb.67.1446066707261; Wed, 28 Oct 2015 14:11:47 -0700 (PDT) Received: by 10.28.100.130 with HTTP; Wed, 28 Oct 2015 14:11:47 -0700 (PDT) In-Reply-To: <CAHKdp-nbP6e6aDyU3hs3o7PfORsW=1xaEJ4Zyp8QNrubXUeQDg@mail.gmail.com> References: <CADm_WcaLQzigsdmFR43JqiCYJVpmqkhVDc8GiVG=UN+Z1zg7+w@mail.gmail.com> <CAAox1Hg-O7Y63mH6RQCtWqZRL52MZK6xSAxgBDDXhf6_bHkH0w@mail.gmail.com> <CAHKdp-nbP6e6aDyU3hs3o7PfORsW=1xaEJ4Zyp8QNrubXUeQDg@mail.gmail.com> Date: Wed, 28 Oct 2015 17:11:47 -0400 Message-ID: <CADm_WcYYgumV8mYO1zvW-dwzR4j9Sp4Hp6Zef4vDO8aVN-eTmg@mail.gmail.com> From: Jeff Garzik <jgarzik@gmail.com> To: Sean Lynch <seanl@literati.org> Content-Type: multipart/alternative; boundary=001a11443518686dcc052330a43e X-Spam-Status: No, score=-2.7 required=5.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW autolearn=ham version=3.3.1 X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on smtp1.linux-foundation.org Cc: Bitcoin development mailing list <bitcoin-dev@lists.linuxfoundation.org> Subject: Re: [bitcoin-dev] [patch] Switching Bitcoin Core to sqlite db X-BeenThere: bitcoin-dev@lists.linuxfoundation.org X-Mailman-Version: 2.1.12 Precedence: list List-Id: Bitcoin Development Discussion <bitcoin-dev.lists.linuxfoundation.org> List-Unsubscribe: <https://lists.linuxfoundation.org/mailman/options/bitcoin-dev>, <mailto:bitcoin-dev-request@lists.linuxfoundation.org?subject=unsubscribe> List-Archive: <http://lists.linuxfoundation.org/pipermail/bitcoin-dev/> List-Post: <mailto:bitcoin-dev@lists.linuxfoundation.org> List-Help: <mailto:bitcoin-dev-request@lists.linuxfoundation.org?subject=help> List-Subscribe: <https://lists.linuxfoundation.org/mailman/listinfo/bitcoin-dev>, <mailto:bitcoin-dev-request@lists.linuxfoundation.org?subject=subscribe> X-List-Received-Date: Wed, 28 Oct 2015 21:11:49 -0000 --001a11443518686dcc052330a43e Content-Type: text/plain; charset=UTF-8 On Wed, Oct 28, 2015 at 4:28 PM, Sean Lynch <seanl@literati.org> wrote: > On Fri, Oct 23, 2015 at 1:23 AM Lucas Betschart via bitcoin-dev < > bitcoin-dev@lists.linuxfoundation.org> wrote: > >> Facebook has a LevelDB fork which is maintained. >> It's called RocksDB and the API seems to be nearly the same as for >> LevelDB, thus maybe easy to replace: http://rocksdb.org/ >> https://github.com/facebook/rocksdb >> >> Although I don't know if we might have some negative effects for our >> use-case since RocksDB was optimized for big databases running on multiple >> cores. >> > > While RocksDB is pretty decent, note that it's optimized for flash. Not > sure how well it will work on spinning disks. > That's OK for our purposes. We have a huge database which already incentivized having zero seek time. --001a11443518686dcc052330a43e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">On Wed, Oct 28, 2015 at 4:28 PM, Sean Lynch <span dir=3D"l= tr"><<a href=3D"mailto:seanl@literati.org" target=3D"_blank">seanl@liter= ati.org</a>></span> wrote:<br><div class=3D"gmail_extra"><div class=3D"g= mail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bo= rder-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div class=3D"g= mail_quote"><span class=3D""><div dir=3D"ltr">On Fri, Oct 23, 2015 at 1:23 = AM Lucas Betschart via bitcoin-dev <<a href=3D"mailto:bitcoin-dev@lists.= linuxfoundation.org" target=3D"_blank">bitcoin-dev@lists.linuxfoundation.or= g</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin= :0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">F= acebook has a LevelDB fork which is maintained.<div>It's called RocksDB= and the API seems to be nearly the same as for LevelDB, thus maybe easy to= replace:=C2=A0<a href=3D"http://rocksdb.org/" target=3D"_blank">http://roc= ksdb.org/</a> =C2=A0=C2=A0<a href=3D"https://github.com/facebook/rocksdb" t= arget=3D"_blank">https://github.com/facebook/rocksdb</a></div><div><br></di= v><div>Although I don't know if we might have some negative effects for= our use-case since RocksDB was optimized for big databases running on mult= iple cores.</div></div></blockquote><div><br></div></span><div>While RocksD= B is pretty decent, note that it's optimized for flash. Not sure how we= ll it will work on spinning disks. =C2=A0</div></div></div> </blockquote></div><br></div><div class=3D"gmail_extra">That's OK for o= ur purposes.=C2=A0 We have a huge database which already incentivized havin= g zero seek time.</div><div class=3D"gmail_extra"><br></div><div class=3D"g= mail_extra"><br></div></div> --001a11443518686dcc052330a43e--