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.