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