RE: [INTERFACES] JDBC Query performance - Mailing list pgsql-interfaces

From Peter T Mount
Subject RE: [INTERFACES] JDBC Query performance
Date
Msg-id Pine.LNX.4.04.9903211743370.16622-100000@maidast.retep.org.uk
Whole thread Raw
In response to RE: [INTERFACES] JDBC Query performance  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List 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@retep.org.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


pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] 6.4.2 psql/libpq not returning after error
Next
From: "Sam O'Connor"
Date:
Subject: type error inserting large obj, Win32 ODBC