Multiple Row Insert vs. Batch

From: Robert DiFalco <robert(dot)difalco(at)gmail(dot)com>
To: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Multiple Row Insert vs. Batch
Date: 2015-06-06 16:34:47
Message-ID: CAAXGW-yACAgMsW+qikxPJq_6Dn_jZxbygM7h6FdT3foDce3pvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Say I need to insert 250 rows. Is single-statement multiple row insert or
JDBC batch likely to be faster?

Thanks!

R.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2015-06-06 17:29:44 Re: Multiple Row Insert vs. Batch
Previous Message Thomas Kellerer 2015-06-03 07:01:10 Re: CallableStatement.getParameterMetaData() throws exception for valid {call ...} statement