Performance Limitations with using JDBC addBatch()
Posted on 2002-05-31
I've yet to find an article that explains possible performance hits when using the addBatch() functionality. I'm iterating over around a million records and I was wondering if there is a difference between me using addBatch() for all the records, or whether I should call executeBatch() at certain intervals. Basically I'm wondering if executeBatch is going to somehow free up memory resources.