From: Byron Nikolaidis <byronn@insightdist.com>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Use Declare/Fetch option
Date: Wed, 27 Jan 1999 10:59:53 -0500
Message-ID: <36AF37F9.7EFA27E1@insightdist.com> (raw)
References: <000201be49dd$05fe3b20$2801007e@cadzone.tpf.co.jp>
Hiroshi Inoue wrote:
> Hello all,
>
> I have a question about psqlodbc driver.
> Now the default setting for "Use Declare/Fetch" is false.
>
> In MVCC thanks to Vadim,readers block no writers.
> So we can change the [Use Declare/Fetch] option to true ?
> And if so,it's effective ?
>
All you say is correct. It probably could go back to true. But I
think some people would probably prefer it stay false, because there is
more odbc functionality provided with this setting. For example, when
the option is false, the entire SQLExtendedFetch functionality is
supported (prev,first,last,next,absolute,relative,bookmark). When the
Declare/Fetch option is true, only fetch "next" is supported. There are
more things like this.
If you have extremely large result sets, then setting the option to true
would prevent the driver from sucking down all your memory. And when
the MVCC is available, the problem of locking rows won't be a problem
anymore. For small to medium result sets, setting the option to false
will probably result in faster performance.
A future enhancement I have in mind for the driver is using both memory
and files for caching large result sets and/or using a combination of
both kinds of tuple access.
Byron
> Thanks.
>
> Hiroshi Inoue
> Inoue@tpf.co.jp
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, Inoue@tpf.co.jp
Subject: Re: [INTERFACES] Use Declare/Fetch option
In-Reply-To: <36AF37F9.7EFA27E1@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox