--- Jerry Lam <jlam@sandvine.com> wrote:
> Hi,
>
> Is it possible to ask postgresql odbc driver to
> fetch the resulsets from the table one at a time
> instead of fetching all millions rows into memory?

Perhaps setting the "Use declare/fetch" driver option
to true will help you. This will cause a server side
cursor to be used, which will return the rows in
blocks. What controls the size of the blocks, I have
no idea; I've never messed with that.

>
> Thank you,
>
> Jerry
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

You can use in the odbc.ini configuration the following
definitions:

Fetch = 2048
UseDeclareFetch = 1

"Fetch" defines the number of rows to fetch at a time.
UseDeclareFetch activates the feature.

Regards,
Marko Ristola

Jeff Eckermann wrote:

>--- Jerry Lam <jlam@sandvine.com> wrote:
>
>
>>Hi,
>>
>>Is it possible to ask postgresql odbc driver to
>>fetch the resulsets from the table one at a time
>>instead of fetching all millions rows into memory?
>>
>>
>
>Perhaps setting the "Use declare/fetch" driver option
>to true will help you. This will cause a server side
>cursor to be used, which will return the rows in
>blocks. What controls the size of the blocks, I have
>no idea; I've never messed with that.
>
>
>
>>Thank you,
>>
>>Jerry
>>
>>---------------------------(end of
>>broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faq
>>
>>
>>
>
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Small Business - Try our new resources site!
>http://smallbusiness.yahoo.com/resources/
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org