From: | Allan Kamau <kamauallan(at)gmail(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 100 times faster than mysql |
Date: | 2011-07-26 14:02:12 |
Message-ID: | CAF3N6oRXzXf0+eBaUWE-AUzO+R2U3UZV9qGSoD3UnrXOPifSkg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mcleod, John | 2011-07-26 14:03:18 | Re: pgsql error |
Previous Message | Merlin Moncure | 2011-07-26 13:41:24 | 100 times faster than mysql |