Home > mailing lists

Re: Multiple Row Insert vs. Batch - Mailing list pgsql-jdbc

From	Dave Cramer
Subject	Re: Multiple Row Insert vs. Batch
Date	June 6, 2015 20:30:09
Msg-id	CADK3HHK3GGaEjCyPStaFx0MqBvJ07uB2bH-wmgLUkrpAsEASuQ@mail.gmail.com Whole thread Raw
In response to	Multiple Row Insert vs. Batch (Robert DiFalco <robert.difalco@gmail.com>)
Responses	Re: Multiple Row Insert vs. Batch (Vitalii Tymchyshyn <vit@tym.im>)
List	pgsql-jdbc

batch should be faster and if it isn't we did something wrong

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 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.

From: Robert DiFalco
Date: 06 June 2015, 19:34:51
Subject: Multiple Row Insert vs. Batch

From: Vitalii Tymchyshyn
Date: 06 June 2015, 20:34:23
Subject: Re: Multiple Row Insert vs. Batch