Re: 100 times faster than mysql

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: Allan Kamau <kamauallan(at)gmail(dot)com>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 100 times faster than mysql
Date: 2011-07-26 19:58:24
Message-ID: e97700919d2c34bda368e0b5a7b49330@mail.softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 26 Jul 2011 17:02:12 +0300, Allan Kamau wrote:
> On Tue, Jul 26, 2011 at 4:41 PM, Merlin Moncure <mmoncure(at)gmail(dot)com>
> wrote:
>> http://codesynthesis.com/~boris/blog/2011/07/26/odb-1-5-0-released/
>>
>> merlin
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>
> "The surprising part is that PostgreSQL 9.0.4 is more than 100 times
> faster on this test than MySQL 5.1.49 with the InnoDB backend (186s
> for MySQL, 48s for SQLite, and 12s for PostgreSQL). Postgre
> developers
> seem to be doing something right."
>
>
> If the speed is to be measured purely (and simply) on these numbers,
> 186/12 yields 15.5 (or maybe 16 if your round it up or 15 if you use
> integer division). May be about 15~16 times faster would be more in
> line with numbers provided.
>
>
> Allan.
Congratulations, but those number are little bit unrealistic. 50 micro
seconds per query - maybe they use ODB caching?

Regards,
Radek

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2011-07-26 22:46:34 Re: heavy load-high cpu itilization
Previous Message Merlin Moncure 2011-07-26 19:53:35 Re: select all rows where any column is NULL