From: | Dave Harkness <daveh(at)MEconomy(dot)com> |
---|---|
To: | "Arsalan Zaidi" <azaidi(at)directi(dot)com> |
Cc: | "PostgreSQL jdbc list" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: java.lang.OutOfMemory Exception with a large number |
Date: | 2001-10-03 19:44:17 |
Message-ID: | 5.1.0.14.2.20011003124129.00abc7e0@mail.meconomy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Billy G. Allie | 2001-10-04 05:15:15 | Announcing the release of pyPgSQL 1.6 |
Previous Message | Rene Pijlman | 2001-10-03 17:45:17 | Re: java.lang.OutOfMemory Exception with a large number of inserts |
From | Date | Subject | |
---|---|---|---|
Next Message | David Siebert | 2001-10-03 21:26:29 | Still getting the timestamp error. |
Previous Message | Dave Harkness | 2001-10-03 19:40:39 | Re: org.postgresql package |