Mailing-List: contact cayenne-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cayenne-user@incubator.apache.org
Received-SPF: pass (asf.osuosl.org: domain of lachlan@ish.com.au designates
 218.214.52.22 as permitted sender)
Mime-Version: 1.0 (Apple Message framework v749.3)
In-Reply-To: <445A9FC3.1030002@bristowhill.com>
References: <71D8D9B8-D492-4153-8A2F-D96A539264AF@ish.com.au>
 <445A9FC3.1030002@bristowhill.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <2A946BE0-9C32-46A0-9768-AE48527465CC@ish.com.au>
Content-Transfer-Encoding: 7bit
From: Lachlan Deck <lachlan@ish.com.au>
Subject: Re: EmbeddedDriver performance help
Date: Fri, 5 May 2006 11:17:34 +1000
To: cayenne-user@incubator.apache.org

Hi there,

On 05/05/2006, at 10:43 AM, Jean T. Anderson wrote:

> Lachlan Deck wrote:
>>
>> I've been testing an initial population of a Derby database with some
>> 30-40000 records and am finding a large performance difference   
>> between
>> using the EmbeddedDriver vs the ClientDriver i.e., depending  on  
>> whether
>> Derby is run as an embedded or network service for the  application.
>>
>> Using the Embedded driver seems to take an order of magnitude longer
>> than not (e.g., 2-3 hours vs 15 minutes)!
>
> fascinating. Normally the embedded driver is faster.

So I've read.

> Which client JDBC driver are you using?

For embedded Derby: org.apache.derby.jdbc.EmbeddedDriver
For network Derby: org.apache.derby.jdbc.ClientDriver

Both are using the adaptor:  
org.objectstyle.cayenne.dba.derby.DerbyAdapter

> Which specific version of Derby are you running?  Can you post the
> output from:

I've tried both the lastest stable and recent nightly build. No  
difference.

> java org.apache.derby.tools.sysinfo

$ java -cp "<..>lib/derby.jar"  org.apache.derby.tools.sysinfo
------------------ Java Information ------------------
Java Version:    1.5.0_06
Java Vendor:     Apple Computer, Inc.
Java home:       /System/Library/Frameworks/JavaVM.framework/Versions/ 
1.5.0/Home
Java classpath:  "<..>lib/derby.jar:/System/Library/Frameworks/ 
JavaVM.framework/Versions/1.5.0/Classes/.compatibility/ 
14compatibility.jar
OS name:         Mac OS X
OS architecture: ppc
OS version:      10.4.6
Java user name:  lachlan
Java user home:  /Users/lachlan
Java user dir:   /Users/lachlan
java.specification.name: Java Platform API Specification
java.specification.version: 1.5
--------- Derby Information --------
JRE - JDBC: J2SE 5.0 - JDBC 3.0
[<...>lib/derby.jar] 10.1.2.1 - (330608)
------------------------------------------------------
----------------- Locale Information -----------------
------------------------------------------------------
lachlans-imac:~ lachlan$

Lachlan Deck
lachlan@ish.com.au
+61 2 9550 5001