JDBC Performance - Mailing list pgsql-sql

From Craig May
Subject JDBC Performance
Date
Msg-id 20001016194950.A13910@s2.enthdimension.com.au
Whole thread Raw
In response to Re: Antw: many-many mapping between unique tables  (Indraneel Majumdar <indraneel@www.cdfd.org.in>)
List pgsql-sql
Hi,

I've been using the postgresql.Driver with JDBC for some time. 

Initially, I was passing Statement objects through functions to each of the
Classes.

This was working beautifully. 

I have since adapted my application to support MS SQL Server.

SQL Server doesn't allow a statement object to perform multiple queries, so i
have changed the application to create additional Connections.

This has reduced it's performance around 400%.

I'm using the driver contained with Postgresql 7.1

Does anyone have ideas on increasing performance with multiple connections?

Kind Regards,
Craig May

Enth Dimension
http://www.enthdimension.com.au



pgsql-sql by date:

Previous
From: "Gerhard Dieringer"
Date:
Subject: Re: Antw: many-many mapping between unique tables
Next
From: Indraneel Majumdar
Date:
Subject: Re: Antw: many-many mapping between unique tables