1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
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--
|