Hi. 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. I tried running the JVM with heap size set to 50 Mbytes. I still get the out of mem error. I can't use the 'load' command instead of individual inserts. Is there a faster/better way? Any ideas on how I can get rid of the out of mem errors? Thanks in advance --Arsalan ------------------------------------------------- WAR IS PEACE FREEDOM IS SLAVERY IGNORANCE IS STRENGTH --1984 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])