From: Robert John Shepherd <robert@reviewer.co.uk>
To: pgsql-performance@postgresql.org
Subject: Best ODBC cursor and lock types for fastest reading?
Date: Tue, 29 Apr 2003 14:53:18 +0100
Message-ID: <001701c30e56$b0964400$f3b0313e@LAIKA> (raw)
I access Postgresql through the ODBC driver, and always only read small
recordsets (never updating them) with forward cursors.
The following options are defined in ADO with which I can create a
recordset with:
Cursor types:
adOpenForwardOnly (what I currently use)
adOpenKeyset
adOpenDynamic
adOpenStatic
Lock types:
adLockReadOnly
adLockPessimistic
adLockOptimistic (what I currently use)
adLockBatchOptimistic
Do any of these offer a performance gain over others? I used to use
adLockReadOnly with MS-SQL which really sped things up but this doesn't
seem to work at all under Postgresql and I've been using
adLockOptimistic instead.
Yours Unwhettedly,
Robert John Shepherd.
Editor
DVD REVIEWER
The UK's BIGGEST Online DVD Magazine
http://www.dvd.reviewer.co.uk
For a copy of my Public PGP key, email: pgp@robertsworld.org.uk
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: robert@reviewer.co.uk
Subject: Re: Best ODBC cursor and lock types for fastest reading?
In-Reply-To: <001701c30e56$b0964400$f3b0313e@LAIKA>
References: <001701c30e56$b0964400$f3b0313e@LAIKA>
* 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