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=-1.9 required=5.0 tests=BAYES_00,FREEMAIL_FROM autolearn=unavailable autolearn_force=no version=3.4.4 X-Received: by 10.66.65.75 with SMTP id v11mr2439092pas.30.1411027726410; Thu, 18 Sep 2014 01:08:46 -0700 (PDT) X-Received: by 10.182.246.69 with SMTP id xu5mr33506obc.9.1411027726256; Thu, 18 Sep 2014 01:08:46 -0700 (PDT) Path: border1.nntp.dca1.giganews.com!nntp.giganews.com!h15no779232igd.0!news-out.google.com!ef6ni14504igb.0!nntp.google.com!h15no779225igd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.lang.ada Date: Thu, 18 Sep 2014 01:08:46 -0700 (PDT) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=194.98.77.125; posting-account=6yLzewoAAABoisbSsCJH1SPMc9UrfXBH NNTP-Posting-Host: 194.98.77.125 References: <10k8o95prdhuj$.195flbmen5kex.dlg@40tude.net> <122qvkxwx9207$.x2ietmtp83wg$.dlg@40tude.net> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <815a16a3-2393-4045-9e0a-3bb28123d26a@googlegroups.com> Subject: Re: Ada vs SQLite3 benchmark From: briot.emmanuel@gmail.com Injection-Date: Thu, 18 Sep 2014 08:08:46 +0000 Content-Type: text/plain; charset=ISO-8859-1 Xref: number.nntp.dca.giganews.com comp.lang.ada:189043 Date: 2014-09-18T01:08:46-07:00 List-Id: Why did you run the benchmarks without optimization ? That seems inconsistent. If you are measuring performance, you should run with full optimization on I think. Also, it would be interesting to use the following pragmas (combined or not) in sqlite, since they can impact performance significantly: pragma journal_mode=WAL; pragma synchronous=OFF; (unless the Ada code is also running fsync() regularly) I think the latter in particular will significantly change the time measured for sqlite. But I agree with your conclusion that Ada is a viable alternative here, thanks for the experiment !