Re: Out of memory troubles with version 8.01.01.02 - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Out of memory troubles with version 8.01.01.02
Date
Msg-id 20051213155309.GA6005@soptik.pzkagis.cz
Whole thread Raw
In response to Re: Out of memory troubles with version 8.01.01.02  (tomas@nocrew.org (Tomas Skäre))
List pgsql-odbc
> >   I know about this limitation. There is problem ODBC keep all rows
> > in memory (+ result from libpq = 2 x result). Please try check
> > Use Declare/Fetch option. There is no twice result in memory in psqlODBC.
> > If it doesn't help you can try older releases which mayde do not do this.
> > Please try 8.00.X or even 7.03.209 (if you find it somewhere).
> > I know we're suggesting 8.01.X but few people work with so big
> > datasets.
>
> Does it keep everything in memory when using cursors too?

New releases (8.01.X) keep everything in memory. There is no option
to change it. I have an idea how to do it but time ...

Older releases (8.00.X or 7.X - not based on libpq) maybe do not keep
everything in memory.

Regards,

Luf

pgsql-odbc by date:

Previous
From: tomas@nocrew.org (Tomas Skäre)
Date:
Subject: Re: Out of memory troubles with version 8.01.01.02
Next
From: Filip Wuytack
Date:
Subject: Re: Out of memory troubles with version 8.01.01.02