db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: Derby Procedure performance
Date Thu, 01 Feb 2007 20:18:17 GMT
Dave Been wrote:
> I hear this question was recently discussed (last week?) but was 
> embedded in another subject, maybe someone can point me to the subject 
> so i can find it in the archives.
> I have not found it so far.
> Using the *Embedded *driver (not network server), I have an application 
> with 3 PreparedStatements which do a *select*/*update *qualified on 1 
> row via indexed column, and an *insert* over a single table.
> Would there be any performance gain putting the 3 PreparedStatements 
> into a Java Procedure so all are executed locally within the database?
> The parameters are 3 input ints, one String/varchar 1 - 256 bytes in 
> length, one OUT int value.
> If there is any hope i can try it and time it, but if there is no hope 
> it would save me the effort.



View raw message