JDBC batching
От | Tony DeWitt |
---|---|
Тема | JDBC batching |
Дата | |
Msg-id | CCELIKPGJPFFONABGGNOMEDPCAAA.dewitt@eizel.com обсуждение исходный текст |
Ответ на | Re: Handling null values in char fields from JDBC ("Paulo Merson" <paulo@summa-tech.com>) |
Ответы |
Re: JDBC batching
|
Список | 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
В списке pgsql-jdbc по дате отправления: