It shouldn't be too hard to put some timing code into your program to find out how long each of those two statements runs for. Why don't you try that first? That would get rid of the rumours and put control back in your hands.
posted 7 years ago
Thanks. I have pinpointed the bottleneck/slowdown:
statement.execute(); is taking 1 1/2 hours to complete. I am assuming at this point that my slowdown is originating in the way the Stored Procedures were written.