Re: setFetchSize

On 17/07/2003 14:24 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's memory?
>   I'm trying to search in the archives but any search I try returns 0
> results...

Not AFAIK. A work-round might be to use limit and offset in your sql.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+