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: 
 border2.nntp.dca1.giganews.com!nntp.giganews.com!newspeer1.nac.net!feeder.erje.net!eu.feeder.erje.net!news2.arglkargh.de!news.mixmin.net!aioe.org!.POSTED!not-for-mail
From: Pascal Obry <pascal@obry.net>
Newsgroups: comp.lang.ada
Subject: Re: Ada vs SQLite3 benchmark
Date: Thu, 18 Sep 2014 19:09:31 +0200
Organization: Home - http://www.obry.net
Message-ID: <1411060171.21609.110.camel@obry.net>
References: <10k8o95prdhuj$.195flbmen5kex.dlg@40tude.net>
Reply-To: pascal@obry.net
NNTP-Posting-Host: pZUE9OU6YbAUqG6GshejDQ.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Complaints-To: abuse@aioe.org
X-Mailer: Evolution 3.12.6-1 
X-Notice: Filtered by postfilter v. 0.8.2
Xref: number.nntp.dca.giganews.com comp.lang.ada:189048
Date: 2014-09-18T19:09:31+02:00
List-Id: <comp.lang.ada>

Le mercredi 17 septembre 2014 =C3=A0 18:51 +0200, Dmitry A. Kazakov a
=C3=A9crit :=20
> I posted benchmark of Ada persistent B-tree vs. SQLite3 at Ada Programmin=
g
> blog:
>=20
> http://ada-programming.blogspot.de/2014/09
>=20
> The implementation of B-tree is based on Ada.Direct_IO with a transaction
> layer, e.g. for safety against system failure.

Ok, but you don't have the full SQL language. For my v2p application I
do have some complex SQL transaction that would be difficult to
translate in plain Direct_IO call.

But if SQL is not needed your B-tree looks quite nice.

--=20
  Pascal Obry /  Magny Les Hameaux (78)

  The best way to travel is by means of imagination

  http://v2p.fr.eu.org
  http://www.obry.net

  gpg --keyserver keys.gnupg.net --recv-key F949BD3B