Thread: 100 times faster than mysql
On Tue, Jul 26, 2011 at 4:41 PM, Merlin Moncure <mmoncure@gmail.com> wrote: > http://codesynthesis.com/~boris/blog/2011/07/26/odb-1-5-0-released/ > > merlin > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.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.
On Tue, 26 Jul 2011 17:02:12 +0300, Allan Kamau wrote: > On Tue, Jul 26, 2011 at 4:41 PM, Merlin Moncure <mmoncure@gmail.com> > wrote: >> http://codesynthesis.com/~boris/blog/2011/07/26/odb-1-5-0-released/ >> >> merlin >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.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
On 07/26/2011 10:02 AM, Allan Kamau wrote: > 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. > I guess he did the math on MySQL, too. Could be worse; could have ran into http://bugs.mysql.com/bug.php?id=33704 which, as you can see, is totally not a bug. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
On Tue, Jul 26, 2011 at 3:53 PM, Greg Smith <greg@2ndquadrant.com> wrote: > I guess he did the math on MySQL, too. Could be worse; could have ran into > http://bugs.mysql.com/bug.php?id=33704 which, as you can see, is totally not > a bug. > Or transactions deadlocking against themselves. Best Wishes, Chris Travers