From: Byron Nikolaidis <byronn@insightdist.com>
To: Christian Steindl <e9425178@student.tuwien.ac.at>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] scrollable cursor via odbc
Date: Mon, 29 Jun 1998 14:10:06 -0400
Message-ID: <3597D87E.1E90176E@insightdist.com> (raw)
References: <Pine.A41.3.95.980629182008.74084A-100000@stud1.tuwien.ac.at>
Christian Steindl wrote:
> i use the odbc interface to the postgresql but it seems to be quite
> slowly.
> although it's a single table with about 20.000 rows.
> i set a link in an access-db and scrolling (next page, last row) is very
> slowly.
> is there a way to optimize the performance?
> can i use scrollable cursor via the odbc-drv?
>
We need more information than the subjective "slow".
First of all, what version of the driver are you using?
Also, there are numerous reasons besides the driver that the performance can
be slow.
Are you using an index on your table?
Are you using a unique identifier in Access? The kind of queries this
generates (multiple OR's) can be extremely slow because of the backend
canonifier problem.
Is the system postgres is running on slow?
Do you have the "Use Declare/Fetch" driver option checked?
If you are using a unique identifier, is it a single keypart or multiples?
Byron
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, e9425178@student.tuwien.ac.at
Subject: Re: [INTERFACES] scrollable cursor via odbc
In-Reply-To: <3597D87E.1E90176E@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