From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: Ada vs SQLite3 benchmark
Date: Thu, 18 Sep 2014 09:31:09 +0200
Date: 2014-09-18T09:31:09+02:00 [thread overview]
Message-ID: <1dqhz2v8srsn5.3yatqlo05shu.dlg@40tude.net> (raw)
In-Reply-To: lvd894$mjv$1@dont-email.me
On Wed, 17 Sep 2014 17:16:35 -0700, Jeffrey Carter wrote:
> On 09/17/2014 09:51 AM, Dmitry A. Kazakov wrote:
>> I posted benchmark of Ada persistent B-tree vs. SQLite3 at Ada Programming
>> blog:
>>
>> 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.
>
> Is your B-tree/Direct_IO version task safe?
Yes. It uses a persistent memory pool on top of the file. The pool has a
protected object implementing a mutex and tree operations run with the
mutex taken.
> Is your version of SQLite compiled
> to be thread safe?
Should be as the SQLite DB is opened with the FULL_MUTEX option. The
documentation is somehow fuzzy about the effects of FULL_MUTEX, but I
suppose it should make it task-safe.
As far as I can tell the most time-consuming part of SQLite operations was
commit. Immutable operations are way quicker.
--
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de
next prev parent reply other threads:[~2014-09-18 7:31 UTC|newest]
Thread overview: 21+ messages / expand[flat|nested] mbox.gz Atom feed top
2014-09-17 16:51 Ada vs SQLite3 benchmark Dmitry A. Kazakov
2014-09-17 23:26 ` gdotone
2014-09-18 0:16 ` Jeffrey Carter
2014-09-18 7:31 ` Dmitry A. Kazakov [this message]
2014-09-18 5:50 ` Georg Bauhaus
2014-09-18 7:27 ` Dmitry A. Kazakov
2014-09-18 7:56 ` Georg Bauhaus
2014-09-18 8:05 ` Dmitry A. Kazakov
2014-09-18 8:08 ` briot.emmanuel
2014-09-18 20:08 ` Dmitry A. Kazakov
2014-09-18 8:17 ` Marius Amado-Alves
2014-09-18 13:41 ` Jacob Sparre Andersen
2014-09-18 19:42 ` Dmitry A. Kazakov
2014-09-18 17:09 ` Pascal Obry
2014-09-22 15:43 ` Gour
2014-09-22 16:08 ` Pascal Obry
2014-09-22 17:00 ` Gour
2014-09-22 16:29 ` Dmitry A. Kazakov
2014-09-22 17:02 ` Gour
2014-09-22 19:09 ` Dmitry A. Kazakov
2014-09-22 20:19 ` Gour
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox