Horton

JDBC Performance

Craig May <craig.may@s2.enthdimension.com.au>

View thread View on postgr.es
From: Craig May <craig.may@s2.enthdimension.com.au>
To: pgsql-sql@postgresql.org
Date: 2000-10-16T19:49:50Z
Lists: 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