pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: JDBC Performance
3+ messages / 3 participants
[nested] [flat]

* JDBC Performance
@ 2000-10-16 19:49 Craig May <craig.may@s2.enthdimension.com.au>
  2000-10-16 15:13 ` Re: JDBC Performance Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Craig May @ 2000-10-16 19:49 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: JDBC Performance
  2000-10-16 19:49 JDBC Performance Craig May <craig.may@s2.enthdimension.com.au>
@ 2000-10-16 15:13 ` Josh Berkus <josh@agliodbs.com>
  2000-10-17 19:23   ` Re: JDBC Performance Peter Mount <peter@retep.org.uk>
  0 siblings, 1 reply; 3+ messages in thread

From: Josh Berkus @ 2000-10-16 15:13 UTC (permalink / raw)
  To: pgsql-sql

Mr. May,

	For discussions of JDBC, please subscribe to the pgsql-interfaces
list.  You will find many JDBC users on that list.

					-Josh Berkus

P.S. PGSQL folks, is there any way we can clarify this on the web page? 
The JDBC users seem to keep ending up on this list.

-- 
______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology      josh@agliodbs.com
    and data management solutions       (415) 436-9166
   for law firms, small businesses       fax  436-0137
    and non-profit organizations.       pager 338-4078
                        		San Francisco



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: JDBC Performance
  2000-10-16 19:49 JDBC Performance Craig May <craig.may@s2.enthdimension.com.au>
  2000-10-16 15:13 ` Re: JDBC Performance Josh Berkus <josh@agliodbs.com>
@ 2000-10-17 19:23   ` Peter Mount <peter@retep.org.uk>
  0 siblings, 0 replies; 3+ messages in thread

From: Peter Mount @ 2000-10-17 19:23 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-sql

On Mon, 16 Oct 2000, Josh Berkus wrote:

> Mr. May,
> 
> 	For discussions of JDBC, please subscribe to the pgsql-interfaces
> list.  You will find many JDBC users on that list.
> 
> 					-Josh Berkus
> 
> P.S. PGSQL folks, is there any way we can clarify this on the web page? 
> The JDBC users seem to keep ending up on this list.

I think it needs to be mentioned somewhere on the postgresql site. I've
had this on my site for the last 3 years ;-)

Also, I only get the sql & general lists here at home (retep.org.uk), but
get interfaces at work as well so I can sometimes answer it faster if it's
posted to interfaces.

Peter

-- 
Peter T Mount peter@retep.org.uk http://www.retep.org.uk
PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/
Java PDF Generator http://www.retep.org.uk/pdf/





^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-10-17 19:23 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-16 19:49 JDBC Performance Craig May <craig.may@s2.enthdimension.com.au>
2000-10-16 15:13 ` Josh Berkus <josh@agliodbs.com>
2000-10-17 19:23   ` Peter Mount <peter@retep.org.uk>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox