RE: Interesting test results
No BJ, this was real world data timed with a timer. I have this order import routine that reads legacy data then calls Ofbiz services to create the orders, shipments, invoices, etc. It writes a message to the log file every 10 records. No joins involved. Skip -Original Message- From: 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 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 2:55 PM: 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 intervals. The six is an extrapolation of estimates. This test was importing some data and 22 entities were written using 4 services as well as some direct writes. The results were not so great when just using direct writes using the delegator. Thought others might be interested. No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.10/1421 - Release Date: 5/7/2008 5:23 PM No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.10/1421 - Release Date: 5/7/2008 5:23 PM
Interesting test results
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 intervals. The six is an extrapolation of estimates. This test was importing some data and 22 entities were written using 4 services as well as some direct writes. The results were not so great when just using direct writes using the delegator. Thought others might be interested. No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM
Re: Interesting test results
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, May 8, 2008 at 3:55 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: 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 intervals. The six is an extrapolation of estimates. This test was importing some data and 22 entities were written using 4 services as well as some direct writes. The results were not so great when just using direct writes using the delegator. Thought others might be interested. No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM
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 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 2:55 PM: 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 intervals. The six is an extrapolation of estimates. This test was importing some data and 22 entities were written using 4 services as well as some direct writes. The results were not so great when just using direct writes using the delegator. Thought others might be interested. No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM
