At 12:13 AM 10/3/2001, Arsalan Zaidi wrote: >At one point in my program, I was inserting a large number of rows >(~600,000) using a prepared statement. Here are some things I noticed. > >1. It's very slow! :-) >2. Initially, the cpu monitor shows a high level of cpu utilisation, but >this slowly drops off with a blip every second or so. Basically, things slow >down as the process chugs along. >3. I eventually get a java.Lang.OutOfMemory exception after approx 1:00 - >1:30 hrs.
This is a total guess, but is it possible that the PreparedStatement is gathering warnings on every execution? Try doing stmt.clearWarnings(); inside the loop. I assume that setting parameter values replaces old values immediately, so there''s no real reason to do stmt.clearParameters(); each time as well, but it probably couldn't hurt. :) Peace, Dave ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]