Re: [JDBC] number of transactions doubling

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: "Oliver Jowett" <oliver(at)opencloud(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [JDBC] number of transactions doubling
Date: 2006-09-28 23:03:38
Message-ID: 6992E470F12A444BB787B5C937B9D4DF060E5B0D@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-jdbc

FYI..I use the postgres8.1.404 jdbc driver

-----Original Message-----
From: Oliver Jowett [mailto:oliver(at)opencloud(dot)com]
Sent: Thursday, September 28, 2006 3:24 PM
To: Sriram Dandapani
Cc: pgsql-jdbc(at)postgresql(dot)org; pgsql-admin(at)postgresql(dot)org
Subject: Re: [JDBC] number of transactions doubling

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

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver Jowett 2006-09-28 23:13:41 Re: [JDBC] number of transactions doubling
Previous Message Sriram Dandapani 2006-09-28 22:52:15 Re: [JDBC] number of transactions doubling

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2006-09-28 23:13:41 Re: [JDBC] number of transactions doubling
Previous Message Sriram Dandapani 2006-09-28 22:52:15 Re: [JDBC] number of transactions doubling