| From: | Craig May <craig(dot)may(at)s2(dot)enthdimension(dot)com(dot)au> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | JDBC Performance |
| Date: | 2000-10-16 19:49:50 |
| Message-ID: | 20001016194950.A13910@s2.enthdimension.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Indraneel Majumdar | 2000-10-16 20:13:56 | Re: Antw: many-many mapping between unique tables |
| Previous Message | Indraneel Majumdar | 2000-10-16 18:11:56 | many-many mapping between unique tables |