Interesting test results

[SkipDever]

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

[Brett]

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, skip@thedevers <[hidden email]> 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
>
>

[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.

skip@thedevers 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
>
>
>
>

[SkipDever]

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:[hidden email]]
Sent: Thursday, May 08, 2008 6:21 PM
To: [hidden email]
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.

skip@thedevers 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