Re: Performance of batches with Statements and

From: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Performance of batches with Statements and
Date: 2003-04-09 11:54:09
Message-ID: 20030409085409.7548574c.felipes@ritterdosreis.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

well, someone could make executeBatch() work this way, if it's really better

On Wed, 9 Apr 2003 06:36:54 -0400
"John Guthrie" <jguthrie(at)psynapsetech(dot)net> wrote:

> > 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--

/~\ The ASCII Felipe Schnack (felipes(at)ritterdosreis(dot)br)
\ / Ribbon Campaign Analista de Sistemas
X Against HTML Cel.: 51-91287530
/ \ Email! Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter(at)ritterdosreis(dot)br
Fone: 51-32303341

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message floess 2003-04-09 12:34:43 Re: Callable Statements
Previous Message John Guthrie 2003-04-09 10:36:54 Re: Performance of batches with Statements and PreparedStatements