Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [JDBC] number of transactions doubling
- From: Oliver Jowett <oliver(at)opencloud(dot)com>
- To: Sriram Dandapani <sdandapani(at)counterpane(dot)com>
- Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
- Subject: Re: [JDBC] number of transactions doubling
- Date: Thu, 28 Sep 2006 22:24:28 +0000
Sriram Dandapani wrote:
The target table has triggers that route data to appropriate tables. The tables to which data is routed has check constraints that do further inserts. (All of this happens in 1 jdbc transaction)I expect JDBC Batching to generate fewer transactions depending on batch size.
Have you turned autocommit off? -O
- References:
- number of transactions doubling
- From: Sriram Dandapani
- number of transactions doubling
- Prev by Date: Addendum on stored procedure array limits
- Next by Date: Re: [JDBC] number of transactions doubling
- Previous by thread: number of transactions doubling
- Next by thread: Re: number of transactions doubling
- Indexes: