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