RE: Interesting test results

2008-05-09 Thread [EMAIL PROTECTED]
: BJ Freeman [mailto:[EMAIL PROTECTED] Sent: Thursday, May 08, 2008 6:21 PM To: user@ofbiz.apache.org Subject: Re: Interesting test results clarification was this thru webtools, or the install script that used ofbiz to talk to the db? the other test of interest is read and writes on large data sets

Re: Interesting test results

2008-05-08 Thread BJ Freeman
clarification was this thru webtools, or the install script that used ofbiz to talk to the db? the other test of interest is read and writes on large data sets in a table and joined. Mysql has had issues in large data storage and multiple queries. [EMAIL PROTECTED] sent the following on 5/8/2008

Re: Interesting test results

2008-05-08 Thread Brett Palmer
I have noticed similar response times when doing a build run-install with Derby and Postgres. I would be interested in seeing the performance difference with Postgres vs. MySQL. In the past MySQL was faster but we didn't use it because of the poor transaction support in MySQL. Brett On Thu, Ma

Interesting test results

2008-05-08 Thread [EMAIL PROTECTED]
I was doing some testing last night and discovered that the combination of Ofbiz and Derby vs Ofbiz and Postgres was pretty amazing. Ofbiz using Postgres on a Windows box was about 6 to 10 times faster than when using Derby. The 10 was observed when watching the progress over 10 1 minute interval