Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group