Performance question, Closing Prepared statements

2011-03-08 Thread Malte.Kempff
Hi to all, I'd like to do huge manipulation on a single table. Jowning there is a routine within derby to do bulk imports though, I cannot really use it, snce there are updates inserts and deletes to be done interpreting some command field with in each record. I am not quite sure if it is state

Re: Performance question, Closing Prepared statements

2011-03-08 Thread Bryan Pendleton
On 03/08/2011 10:01 AM, malte.kem...@de.equens.com wrote: close prepared statement after each operation, because there might be a pooling within derby or derby driver for those statements, or should I rather leave those three kinds of prepared statements (insert, update delete) open till my