Postgres from 9.1 has good replication -----Original Message----- From: Brett Palmer [mailto:brettgpal...@gmail.com] Sent: Thursday, June 21, 2012 10:04 PM To: user@ofbiz.apache.org Subject: Re: Ofbiz with MySQL or PostgreSQL
Sanjeev, We've used MySQL for several years now. I think most ofbiz user prefer Postgres. We like Postgres but the one feature that keeps us with MySQL is its replication feature. Replication in MySQL is very good and easy to administer. We use them for running reports which helps us scale our solution. We have a data warehouse with a fact table of over 30+ million rows and mysql does a good job with it. Brett On Thu, Jun 21, 2012 at 8:47 PM, Sanjeev Gupta <subscr...@sanjeevg.com>wrote: > Thanks Ruth. > I've also been told that the demo data upload in Postgres takes half as > time > as MySQL - so I'm guessing that the production env performance should also > be better with Postgres. > > ----- > Rgds > Sanjeev > www.sanjeevg.com > @sanjeevgcom > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Ofbiz-with-MySQL-or-PostgreSQL-tp4633893p4 633907.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >