Re: JDBC batching
От | Ed Yu |
---|---|
Тема | Re: JDBC batching |
Дата | |
Msg-id | AE6FF3A533861C41A6571F1D7DDF6F6112827E@asgnet2.asg.sc.edu обсуждение исходный текст |
Ответ на | JDBC batching ("Tony DeWitt" <dewitt@eizel.com>) |
Список | pgsql-jdbc |
Yeah, I've submitted a patch and according to Barry, it was already fixed. If not, I can re-submit the patch. -----Original Message----- From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Tony DeWitt Sent: Tuesday, January 29, 2002 10:49 AM To: Barry Lind Cc: pgsql-jdbc@postgresql.org Subject: Re: [JDBC] JDBC batching It does not appear to be so. I grabbed 7.2rc2, and the JDBC driver shipped with it still implements a batch update with multiple round trips. I verified this both by sniffing the network packets, reading the shipped code, and disassembling the Statement class that I'm running. I even checked the CVS repository at jdbc.postgresql.org. Am I missing something here? Thanks, Tony -----Original Message----- From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Barry Lind Sent: Tuesday, January 22, 2002 3:47 PM To: Tony DeWitt Cc: pgsql-jdbc@postgresql.org Subject: Re: [JDBC] JDBC batching Tony, The batch API works in one round trip in 7.2. thanks, --Barry Tony DeWitt wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
В списке pgsql-jdbc по дате отправления: