Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Date: Fri, 10 Aug 2007 11:25:31 +0200
From: Thomas Nielsen <Thomas.Nielsen@Sun.COM>
Subject: Re: Accessing embedded database in JAR file
In-reply-to: <42652533-2881-4749-8966-1567B574B69E@bio.gla.ac.uk>
Sender: Thomas.Nielsen@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <46BC2F0B.2060209@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <42652533-2881-4749-8966-1567B574B69E@bio.gla.ac.uk>
User-Agent: Thunderbird 2.0.0.0 (X11/20070419)

David Leader wrote:
>> Does it take that long to start if you use ij as well? Does it make a 
>> difference wether you run embedded or not?
> 
> Using ij it certainly doesn't take as long, but there is a perceptable 
> lag before the database connection is made, and the first time a query 
> is made it is perceptably slower than the second time - perhaps just a 
> second compared with apparently instantaneous. I haven't done anything 
> in a non-embedded setup, but I guess you are right and it's something 
> one just has to live with. 

If using ij is a lot faster, then there might be something in your app 
that is causing it to take that long?

Might be worth the effort profiling it using Netbeans, Eclipse, jFluid 
or similar?

> Despite a few problems in porting the stuff 
> from MySQL, I must say that overall I'm very pleased with the result. My 
> thanks to the Derby team.

Thanks for letting the community know :)

If you don't mind - what were your top three pains when moving from 
MySQL to Derby?

Cheers,
Thomas
-- 
Thomas Nielsen