Re: Performance of batches with Statements and PreparedStatements - Mailing list pgsql-jdbc

From John Guthrie
Subject Re: Performance of batches with Statements and PreparedStatements
Date
Msg-id 050f01c2fe83$f359e180$3dc810ac@corphq.psynapsetech.net
Whole thread Raw
In response to Performance of batches with Statements and PreparedStatements  (Jeff Kolesky <jeff@edusoft.com>)
Responses Re: Performance of batches with Statements and
List pgsql-jdbc
> If I take the semi-colon approach, I cannot use a PreparedStatement
> easily, which is fine.  I read somewhere that the implementation of
> executeBatch() just executes all of the statements one-by-one, which
> would be as slow as executing separate statements.

seems to me that it wouldn't be as slow. for one thing you'd eliminate all
the network traffic.

john


pgsql-jdbc by date:

Previous
From: Mark French
Date:
Subject: Callable Statements
Next
From: Felipe Schnack
Date:
Subject: Re: Performance of batches with Statements and