Re: How to speed-up inserts with jdbc
От
Steinar H. Gunderson
Тема
Re: How to speed-up inserts with jdbc
Дата
Msg-id
20041111100418.GA2116@uio.no
Ответ на
Re: How to speed-up inserts with jdbc (Edwin Eyan Moragas)
Список
Дерево обсуждения
Need advice on postgresql.conf settings "Shane | SkinnyCorp" <shanew@skinnycorp.com>
Re: Need advice on postgresql.conf settings Tom Lane <tgl@sss.pgh.pa.us>
Re: Need advice on postgresql.conf settings Sean Chittenden <sean@chittenden.org>
Re: Need advice on postgresql.conf settings Jeff <threshar@torgo.978.org>
How to speed-up inserts with jdbc Michael Kleiser <mkl@webde-ag.de>
Re: How to speed-up inserts with jdbc Jeff <threshar@torgo.978.org>
Re: How to speed-up inserts with jdbc Edwin Eyan Moragas <haaktu@gmail.com>
Re: How to speed-up inserts with jdbc "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Re: How to speed-up inserts with jdbc Edwin Eyan Moragas <haaktu@gmail.com>
Re: How to speed-up inserts with jdbc Dave Cramer <pg@fastcrypt.com>
On Thu, Nov 11, 2004 at 04:04:06PM +0800, Edwin Eyan Moragas wrote: > how about using PreparedStatment? that's on the java end. > on the pg end, maybe do a BEGIN before the for loop and > END at the end of the for loop. You don't even need a "BEGIN" and "END"; his code has a setAutoComit(true) before the for loop, which just has to be changed to setAutoCommit(false) (and add an explicit commit() after the for loop, of course). /* Steinar */ -- Homepage: http://www.sesse.net/
В списке pgsql-performance по дате отправления
