Re: 100 times faster than mysql

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