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
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 |