db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yarono <yar...@il.ibm.com>
Subject SQLPrepare + SQLExecute made a great improvement in preformance - is it possible?
Date Thu, 15 Nov 2007 13:35:59 GMT

I wrote a small test comparing between inserting/selecting/updating 10000
statements. One time it was with ExecDirect (the statement was rewritten in
each iteration), and the second time with SQLPrepare, Binding parameters and

The test showed a great improvement in performance when using SQL prepare,
espcially in SELECT.

Is it possible? Does it make sense to get such a great improvement?

here are the results:
*** It took 88 seconds to insert with bind+prepare
*** It took 121 seconds to insert with execDirect
*** Select (bind+prepare) took 3 second
*** Select (execDirect) took 43 second
*** Update (bind+prepare) took 86 second
*** Update (execDirect) took 92 second

View this message in context: http://www.nabble.com/SQLPrepare-%2B-SQLExecute-made-a-great-improvement-in-preformance---is-it-possible--tf4811849.html#a13767550
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message