diff options
| author | Jeff Garzik <jgarzik@gmail.com> | 2015-10-28 17:11:47 -0400 |
|---|---|---|
| committer | bitcoindev <bitcoindev@gnusha.org> | 2015-10-28 21:11:49 +0000 |
| commit | d38dc12f599b7fa01f333dc7e45fc0e613386c9f (patch) | |
| tree | c7fd08a2424d9f3289ef34c7f6ee96031fcc5f97 | |
| parent | 7cc6c566678b794dfa35f6c53eb58c441bcaa1ff (diff) | |
| download | pi-bitcoindev-d38dc12f599b7fa01f333dc7e45fc0e613386c9f.tar.gz pi-bitcoindev-d38dc12f599b7fa01f333dc7e45fc0e613386c9f.zip | |
Re: [bitcoin-dev] [patch] Switching Bitcoin Core to sqlite db
| -rw-r--r-- | 54/a269c8d4c20a577e069815d3c97b415b3e4049 | 114 |
1 files changed, 114 insertions, 0 deletions
diff --git a/54/a269c8d4c20a577e069815d3c97b415b3e4049 b/54/a269c8d4c20a577e069815d3c97b415b3e4049 new file mode 100644 index 000000000..552e6f6e7 --- /dev/null +++ b/54/a269c8d4c20a577e069815d3c97b415b3e4049 @@ -0,0 +1,114 @@ +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-- + |