| From: | "Tony DeWitt" <dewitt(at)eizel(dot)com> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | JDBC batching |
| Date: | 2002-01-22 18:42:48 |
| Message-ID: | CCELIKPGJPFFONABGGNOMEDPCAAA.dewitt@eizel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
I have looked through all the documentation that I can find, as well as the
mailing list archives, and I haven't been able to find the answer to this.
I'm currently running pgsql 7.0.2.
What I'm trying to do is make a large number of writes to a single table in
an efficient way. Currently our code makes a separate request for each
INSERT statement, incurring too many round trips.
I want to convert this to the batch interface, i.e., addBatch() and
executeBatch(), but I read that this is implemented as multiple round trips
anyway in 7.1.x and before. I also read that this might be fixed in 7.2, but
I've been unable to verify this in the documentation.
Can anyone enlighten me on the state of the batching interface? or is there
some better way to do this?
Thank you,
Tony DeWitt
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paulo Merson | 2002-01-22 19:11:38 | Re: Handling null values in char fields from JDBC |
| Previous Message | Sean Duffy | 2002-01-22 18:37:21 | Re: Handling null values in char fields from JDBC |