Caching

From: "Lufkin, Brad" <brad(dot)lufkin(at)ngc(dot)com>
To: 'psql' <pgsql-jdbc(at)postgresql(dot)org>
Subject: Caching
Date: 2003-08-29 19:30:06
Message-ID: 0E253E40DC78F4499CEDDE9223099F430706B821@xcgva040.northgrum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Whenever I execute a query and retrieve the results with the sequence:

ResultSet resultSet = statement.executeQuery("SELECT blah blah
blah...");
while (resultSet.next()) {
//do something with the resultSet
}

it looks like the query is completely carried out before any results are
returned. This contrasts with the behavior of other databases (Informix
comes to mind) where the query returns immediately and the results are
returned as the database fetches them. Is my supposition correct, and, if
so, is there any way to make postgres behave the same way as Informix?
My reasons for wanting this behavior is that I'm displaying results in real
time to a user through a GUI and the gradual display of results is
preferable to a long pause followed by all the results at once.

Responses

  • Re: Caching at 2003-08-29 21:35:14 from Fernando Nasser

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fernando Nasser 2003-08-29 21:35:14 Re: Caching
Previous Message Juan Francisco Diaz 2003-08-29 18:44:08 Am I right?