Hi Sanjeev:
If you use MySQL in its current state, be aware of Timestamp truncation.
Since OFBiz uses timestamps in many places as part of a primary-key, you
can (and do) loose precision and ultimately you may not be able to find
records. You may not even know this is happening until it is too late.
I've been told this has been "fixed" in the lasted (beta?) release of
the JDBC driver.
Personally, I prefer Postgres. Never had a problem and the tools for
maintaining it are the best.
Regards,
Ruth Hoffman (http://www.aesolves.com)
On 6/21/12 2:57 PM, Sanjeev Gupta wrote:
I'm looking to decide on the database to be used with OfBiz in the production
environment. Any thoughts on which database works well with Ofbiz - MySQL or
PostgreSQL and why ?
-----
Rgds
Sanjeev
www.sanjeevg.com
@sanjeevgcom
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/Ofbiz-with-MySQL-or-PostgreSQL-tp4633893.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
