| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Igor Postelnik <Igor_Postelnik(at)messageone(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Batch updates and inserts |
| Date: | 2005-05-09 17:52:39 |
| Message-ID: | Pine.BSO.4.56.0505091250220.5342@leary.csoft.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Mon, 9 May 2005, Igor Postelnik wrote:
> What combination of JDBC driver and backend do I need to have support
> for addBatch/executeBatch? What's a reasonable limit for number of
> statements in a batch - either by number of rows or total size?
>
Batch statements have been available in the driver for some time, but the
8.0 driver is the first driver to actually perform them in a batch
fashion. It requires at least a 7.4 server to take advantage of this.
Size doesn't really matter because the driver itself will internally run
things in batches of 256 statements at a time.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira de Oliveira | 2005-05-10 01:55:23 | Translation update: pt_BR |
| Previous Message | Igor Postelnik | 2005-05-09 17:12:31 | Batch updates and inserts |