I think OP meant something like Insert into table values (?,?,?),(?,?,?),...,(?,?,?); Vs batch of insert into table values(?,?,?);I really think first would be faster up to a certain amount of rows, but test is needed to check.Vitalii TymchyshynСб, 6 черв. 2015 13:30 Dave Cramer <pg@fastcrypt.com> пише:batch should be faster and if it isn't we did something wrongDave Cramerdave.cramer(at)credativ(dot)cahttp://www.credativ.caOn 6 June 2015 at 12:34, Robert DiFalco <robert.difalco@gmail.com> wrote:Say I need to insert 250 rows. Is single-statement multiple row insert or JDBC batch likely to be faster?Thanks!R.
I think OP meant something like Insert into table values (?,?,?),(?,?,?),...,(?,?,?); Vs batch of insert into table values(?,?,?);
I really think first would be faster up to a certain amount of rows, but test is needed to check.
Vitalii Tymchyshyn
batch should be faster and if it isn't we did something wrongDave Cramerdave.cramer(at)credativ(dot)cahttp://www.credativ.caOn 6 June 2015 at 12:34, Robert DiFalco <robert.difalco@gmail.com> wrote:Say I need to insert 250 rows. Is single-statement multiple row insert or JDBC batch likely to be faster?Thanks!R.
Say I need to insert 250 rows. Is single-statement multiple row insert or JDBC batch likely to be faster?Thanks!R.
pgsql-jdbc by date:
Соглашаюсь с условиями обработки персональных данных