Re: SELECT very slow - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: SELECT very slow
Date
Msg-id d88p3j$mb8$2@sea.gmane.org
Whole thread Raw
In response to Re: SELECT very slow  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On 09.06.2005 02:06 Tom Lane wrote:

> Thomas Kellerer <spam_eater@gmx.net> writes:
> 
>>Is there anything I can do, to convince PG to return the first row more 
>>quickly?
> 
> 
> libpq's API for PQresult is such that it really doesn't have any choice
> but to collect the full result set before it hands you back the
> PQresult.  I don't know JDBC very well but I think it has similar
> semantic constraints.
> 
> The solution is to use a cursor and FETCH a reasonably small number of
> rows at a time.
> 

My understanding was that setting the fetchSize() to 1 in JDBC would force the
use of a cursor.

I'll have to go through the JDBC docs again to check how I can enforce this.

Thanks for the answer though
Thomas



pgsql-sql by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: SELECT very slow
Next
From: Bruno Wolff III
Date:
Subject: Re: [despammed] rejecting characters in a field