Re: Performance of batches with Statements and PreparedStatements

From: "John Guthrie" <jguthrie(at)psynapsetech(dot)net>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Performance of batches with Statements and PreparedStatements
Date: 2003-04-09 10:36:54
Message-ID: 050f01c2fe83$f359e180$3dc810ac@corphq.psynapsetech.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Felipe Schnack 2003-04-09 11:54:09 Re: Performance of batches with Statements and
Previous Message Peter Royal 2003-04-08 22:13:22 Index metadata not sorted by ORDINAL_POSITION