Re: setFetchSize

Felipe Schnack wrote:
>   There is a way that I can set setFetchSize() that will prevent pgsql from caching all the results of a query to
server'smemory? 
>   I'm trying to search in the archives but any search I try returns 0 results...
>

Have you tried setting it to a positive value and turning off autocommit
(you must be inside a transaction to do this)?

--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9