| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | Felipe Schnack <felipes(at)ritterdosreis(dot)br> |
| Cc: | "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: setFetchSize |
| Date: | 2003-07-17 15:38:47 |
| Message-ID: | 20030717163847.B28330@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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 |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2003-07-17 15:43:27 | Re: Prepared Statements |
| Previous Message | Dmitry Tkach | 2003-07-17 15:27:23 | Re: Prepared Statements |