Re: How can I configure the postgresql odbc to return 1 row

From: Marko Ristola <marko(dot)ristola(at)kolumbus(dot)fi>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: How can I configure the postgresql odbc to return 1 row
Date: 2005-04-11 18:18:48
Message-ID: 425ABF88.7040709@kolumbus.fi
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-odbc


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(at)sandvine(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message lothar.behrens 2005-04-12 12:19:17 bytea question
Previous Message Marko Ristola 2005-04-11 17:06:32 Re: Driver uses always UTF-8?