Re: sqlite speed comparison

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>, PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: sqlite speed comparison
Date: 2006-02-17 21:09:41
Message-ID: b42b73150602171309u2aecaf7h5d0912af7e6f2715@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/14/06, Neil Conway <neilc(at)samurai(dot)com> wrote:
> On Tue, 2006-02-14 at 13:53 -0500, Kevin Murphy wrote:
> > A Windows PostgreSQL guru who cares (;-)) might help this guy with his
> > benchmark of mysql, firebird, sqlite, and postgresql:
> >
> > http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
>
> Yeah, see recent discussion:
>
> http://archives.postgresql.org/pgsql-hackers/2006-02/msg00465.php

He turned on row level statistics in his postgresql.conf which is
either accidental goof or borderline cheating. This would have
mesurable impact on all rapid fire query tests. editing his wiki atm

merlin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message mmaclennan 2006-02-17 21:26:08 Re: connecting to pgsql
Previous Message Ragnar 2006-02-17 20:33:06 Re: Converting an ASCII database to an UTF-8 database