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 |
+------------------------------+---------------------------------------------+