| Lists: | pgsql-interfaces |
|---|
| From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | "pgsql-interfaces" <pgsql-interfaces(at)postgreSQL(dot)org> |
| Subject: | Use Declare/Fetch option |
| Date: | 1999-01-27 10:08:44 |
| Message-ID: | 000201be49dd$05fe3b20$2801007e@cadzone.tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
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 ?
Thanks.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp
| From: | Byron Nikolaidis <byronn(at)insightdist(dot)com> |
|---|---|
| To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
| Subject: | Re: [INTERFACES] Use Declare/Fetch option |
| Date: | 1999-01-27 15:59:53 |
| Message-ID: | 36AF37F9.7EFA27E1@insightdist.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
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(at)tpf(dot)co(dot)jp
| From: | Clark Evans <clark(dot)evans(at)manhattanproject(dot)com> |
|---|---|
| To: | |
| Cc: | pgsql-interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
| Subject: | Python Interface |
| Date: | 1999-01-28 17:54:47 |
| Message-ID: | 36B0A467.8E336915@manhattanproject.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
Is there a Python interface?
- Clark Evans
| From: | "D'Arcy" "J(dot)M(dot)" Cain <darcy(at)druid(dot)net> |
|---|---|
| To: | clark(dot)evans(at)manhattanproject(dot)com (Clark Evans) |
| Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
| Subject: | Re: [INTERFACES] Python Interface |
| Date: | 1999-01-28 22:20:23 |
| Message-ID: | m105znT-0000bnC@druid.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
Thus spake Clark Evans
> Is there a Python interface?
It's in the interfaces directory. It's also at http://www.druid.net/pygresql/
and the latest beta can be found at ftp://ftp.druid.net/pub/distrib/.
--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.