Re: Users - PostgreSQL 8.1 faster than MySQL 5.0?

Posted by davidnwelton on Apr 03, 2006; 2:49pm
URL: http://ofbiz.116.s1.nabble.com/Users-PostgreSQL-8-1-faster-than-MySQL-5-0-tp138302p138303.html

> I have been using MySQL 5 on Windows XP/SP2 setup and just tried PostgreSQL
> 8.1 for the first time. Here are the ant run-install timings (from empty
> database) on my computer with each:

> MySQL 5                    17 minutes
>
> PostgreSQL 8.1           7 minutes (almost one third of MySQL)

> I thought MySQL was faster than PostgreSQL!

When you turn off 'annoying details' like foreign keys and
transactions, it certainly is, at least for simple selects and
inserts.  I have yet to see any good benchmarks for Mysql 5 with
InnoDB vs Postgresql.  It would be especially interesting to see
benchmarks utilizing more complex queries.

--
David N. Welton
 - http://www.dedasys.com/davidw/

Linux, Open Source Consulting
 - http://www.dedasys.com/
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users