Skip site navigation (1) Skip section navigation (2)

Re: Impact of open ResultSets and PreparedStatements ?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Antony Paul <antonypaul24(at)gmail(dot)com>
Cc: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Impact of open ResultSets and PreparedStatements ?
Date: 2005-04-29 09:58:34
Message-ID: Pine.BSO.4.56.0504290457210.11511@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Fri, 29 Apr 2005, Antony Paul wrote:

> I am using PostgreSQL 7.3 (server and JDBC driver) and no stored
> procedures are used but uses the built in functions. I know that in
> this version PreparedStatements are not kept in the server. What about
> the ResultSet ?. Does all the data is transferred to application right
> after the query is executed or only a predefined no of records are
> returned while going through the rs.next() call ?.
> 

In 7.3 all ResultSets fetch the entire result immediately leaving 
nothing on the server.

Kris Jurka


In response to

pgsql-jdbc by date

Next:From: Oliver SiegmarDate: 2005-04-29 10:25:08
Subject: Re: Interval support for Postgres
Previous:From: Kris JurkaDate: 2005-04-29 09:51:51
Subject: Re: Problems storing timestamps with calendars

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group