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

Re: odbc/ado problems

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: Kroh István <istvan(dot)kroh(at)pomme(dot)hu>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: odbc/ado problems
Date: 2004-08-31 17:33:07
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A7491@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-performance
> 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.

Question: what is your Delphi database driver?  If you are using the BDE, that might be your problem.  Try installing and using the ZeosLib toolkit.

http://www.zeoslib.org

Merlin

pgsql-performance by date

Next:From: Ron St-PierreDate: 2004-08-31 18:11:02
Subject: Table UPDATE is too slow
Previous:From: Kroh IstvánDate: 2004-08-31 17:26:15
Subject: odbc/ado problems

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