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 SQLExecute.
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.
