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: Wed, 11 Jun 2008 14:33:34 +0200
From: =?UTF-8?B?w5h5c3RlaW4gR3LDuHZsZW4=?= <Oystein.Grovlen@Sun.COM>
Subject: Re: Speed of using Derby DB
In-reply-to: <1c6e34b0806110523o5e1d40ackc1861cb45e9468b6@mail.gmail.com>
Sender: Oystein.Grovlen@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <484FC61E.6010303@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=UTF-8
Content-transfer-encoding: 8BIT
References: <1c6e34b0806110131q12339641j841b8c5861f0085a@mail.gmail.com>
 <484FB7BD.2060500@sun.com>
 <1c6e34b0806110456o5c7b581cn15b2739c875f1010@mail.gmail.com>
 <484FC082.2050000@sun.com>
 <1c6e34b0806110523o5e1d40ackc1861cb45e9468b6@mail.gmail.com>
User-Agent: Thunderbird 2.0.0.14 (X11/20080505)

vodarus vodarus wrote:
> I thought tt using stored procedure will avoid transferring data from 
> DataEngine to Application.

That cost is very little when using embedded where both are executing in 
the same VM.

> Using Java + Oracle will be slower than usage of PL/SQL code.

But Java + Oracle implies client/server and transfer of data between 
different processes.

> Application will spend a lot of resources to transfer data from DBMS to 
> external code and back.
> 
> Do you mean usage of Java application itself and avoid usage of stored 
> procedure?

Yes.

> 
> 
>         PS does derby / javaDB have it's own forum?
> 
> 
>     Do you mean outside this mailing list?
> 
> 
> Yes. I think forum is more visual tool for communication than mail-list.

(I would think that depends on your mail client.)

Nabble and several other sites provide a way to access the mailing list 
in as a forum. http://www.nabble.com/Apache-Derby-Users-f93.html

-- 
Øystein