From: Kroh István <istvan.kroh@pomme.hu>
To: pgsql-performance@postgresql.org
To: pgsql-odbc@postgresql.org
Subject: odbc/ado problems
Date: Tue, 31 Aug 2004 19:26:15 +0200
Message-ID: <005a01c48f7f$9ff8ae70$0102a8c0@pomme001> (raw)
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
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: istvan.kroh@pomme.hu, pgsql-odbc@postgresql.org
Subject: Re: odbc/ado problems
In-Reply-To: <005a01c48f7f$9ff8ae70$0102a8c0@pomme001>
* 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