pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Markus Donath <md-postgres-donath@netapps.de>
To: pgsql-odbc@postgresql.org
Subject: Re: odbc/ado problems
Date: Wed, 1 Sep 2004 10:19:48 +0200
Message-ID: <ch40n7$1oqf$1@news.hub.org> (raw)
References: <005a01c48f7f$9ff8ae70$0102a8c0@pomme001>

hello,

did you use a read only / forward only cursor (adOpenForwardOnly) ?
this is the fastest way to retreive data, other cursor types are much slower
with postgres odbc.

bye,
Markus Donath.


"Kroh István" <istvan.kroh@pomme.hu> schrieb im Newsbeitrag
news:005a01c48f7f$9ff8ae70$0102a8c0@pomme001...
> Hi all!
>
> I'm new here, so hello to everybody!
>
> I'm in a deep truble using postgesSQL 7.2.0 on a low-end pc with SUSE 8.
I'm
> using some databases from that pc through odbc (7.3.200). Until now i had
no
> problems with this solution, everithing worked fine. But today i wrote a
> small app, that converts/copies some data from a database to an other
> database.
>
> During this work i wrote a simple query as follows:
> select pers_driving_license from person where pers_id=23456
>
> This should return a single varchar(20) field. Running this query over
> ADO/ODBC from a Delphi app tooks 50-100 secs. If i run this from pgAdmin
II.
> it takes some msecs.
>
> The output of explain is:
> Index Scan using person_id_index on person (cost=0.00..3.14 rows=1
width=4)
>
> Any idea?
>
> Thanks in advance: steve
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>





view thread (5+ messages)  latest in thread

Message-ID: <ch40n7$1oqf$1@news.hub.org>
Permalink:  ../ch40n7$1oqf$1@news.hub.org/
Also on:    postgresql.org/message-id/ch40n7$1oqf$1@news.hub.org

 · 

reply

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-performance@postgresql.org
  Cc: md-postgres-donath@netapps.de, pgsql-odbc@postgresql.org
  Subject: Re: odbc/ado problems
  In-Reply-To: <ch40n7$1oqf$1@news.hub.org>

* 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