Skip site navigation (1) Skip section navigation (2)

odbc/ado problems

From: Kroh István <istvan(dot)kroh(at)pomme(dot)hu>
To: <pgsql-performance(at)postgresql(dot)org>, <pgsql-odbc(at)postgresql(dot)org>
Subject: odbc/ado problems
Date: 2004-08-31 17:26:15
Message-ID: 005a01c48f7f$9ff8ae70$0102a8c0@pomme001 (view raw or flat)
Thread:
Lists: pgsql-odbcpgsql-performance
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


Responses

pgsql-performance by date

Next:From: Merlin MoncureDate: 2004-08-31 17:33:07
Subject: Re: odbc/ado problems
Previous:From: Jean-Max ReymondDate: 2004-08-31 15:27:41
Subject: Performance with Intel Compiler

pgsql-odbc by date

Next:From: Markus DonathDate: 2004-09-01 08:19:48
Subject: Re: odbc/ado problems
Previous:From: Jeff EckermannDate: 2004-08-31 15:10:42
Subject: Re: Can I get Postgresql ODBC to accept ODBC Timestamp escape sequences?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group