Received: from s2.enthdimension.com.au (IDENT:root@[203.36.78.178]) by hub.org (8.10.1/8.11.0) with ESMTP id e9G8paW47626 for ; Mon, 16 Oct 2000 04:51:36 -0400 (EDT) (envelope-from root@s2.enthdimension.com.au) Received: (from root@localhost) by s2.enthdimension.com.au (8.9.3/8.8.7) id TAA13937 for pgsql-sql@postgresql.org; Mon, 16 Oct 2000 19:49:50 GMT Date: Mon, 16 Oct 2000 19:49:50 +0000 From: Craig May To: pgsql-sql@postgresql.org Subject: JDBC Performance Message-ID: <20001016194950.A13910@s2.enthdimension.com.au> Reply-To: craig.may@s2.enthdimension.com.au References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 In-Reply-To: ; from indraneel@www.cdfd.org.in on Mon, Oct 16, 2000 at 20:13:56 +0000 X-Mailer: Balsa 0.8.0 X-Archive-Number: 200010/144 X-Sequence-Number: 1806 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