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