RE: [INTERFACES] JDBC Query performance

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
Cc: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>, Postgres mailing lists <postgres(at)weblynk(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: RE: [INTERFACES] JDBC Query performance
Date: 1999-03-21 17:44:40
Message-ID: Pine.LNX.4.04.9903211743370.16622-100000@maidast.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Sun, 21 Mar 1999, Herouth Maoz wrote:

> At 11:07 +0200 on 18/03/1999, Peter Mount wrote:
>
>
> >
> > The delay is because the driver currently retrieves the entire result
> > into a Vector() before returning the ResultSet.
>
> Couldn't it also be because of Java's usage of network sockets compared to
> psql's use of unix sockets?

There shouldn't be that much of a difference, especially on modern
machines when using either unix domain sockets or network sockets.

Peter

--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Postgres mailing lists 1999-03-21 19:10:57 Re: [INTERFACES] JDBC Query performance
Previous Message Tom Lane 1999-03-21 16:11:29 Re: [INTERFACES] 6.4.2 psql/libpq not returning after error