From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-0.3 required=5.0 tests=BAYES_00,
	REPLYTO_WITHOUT_TO_CC autolearn=no autolearn_force=no version=3.4.4
Path: 
 border1.nntp.dca1.giganews.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!feeds.phibee-telecom.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Georg Bauhaus <bauhaus@futureapps.invalid>
Newsgroups: comp.lang.ada
Subject: Re: Ada vs SQLite3 benchmark
Date: Thu, 18 Sep 2014 07:50:09 +0200
Organization: A noiseless patient Spider
Message-ID: <lvdrqi$s6c$1@dont-email.me>
References: <10k8o95prdhuj$.195flbmen5kex.dlg@40tude.net>
Reply-To: nonlegitur@futureapps.de
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 18 Sep 2014 05:50:10 +0000 (UTC)
Injection-Info: mx05.eternal-september.org;
 posting-host="f645b371eb4894a1010cd6ad28739329";
 logging-data="28876"; mail-complaints-to="abuse@eternal-september.org";
 posting-account="U2FsdGVkX19C3khVDqpSdHbdRYi+lE12MXggzW7yNTI="
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
In-Reply-To: <10k8o95prdhuj$.195flbmen5kex.dlg@40tude.net>
Cancel-Lock: sha1:t49xgXiDp/ZN5RV0QsmHAWUtwPc=
Xref: number.nntp.dca.giganews.com comp.lang.ada:189037
Date: 2014-09-18T07:50:09+02:00
List-Id: <comp.lang.ada>

On 17.09.14 18:51, Dmitry A. Kazakov wrote:
> http://ada-programming.blogspot.de/2014/09
>
> The implementation of B-tree is based on Ada.Direct_IO with a transaction
> layer, e.g. for safety against system failure.

What will the comparison look like if you let SQLite3 open the file
":memory:", thus an in-memory data base? Which will require to then
occasionally .dump its contents into another, persistent SQLite3 database.

http://www.sqlite.org/inmemorydb.html