Search Postgresql Archives

Re: 100 times faster than mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, 26 Jul 2011 17:02:12 +0300, Allan Kamau wrote:
On Tue, Jul 26, 2011 at 4:41 PM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote:
http://codesynthesis.com/~boris/blog/2011/07/26/odb-1-5-0-released/

merlin

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux