> 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.
> using some databases from that pc through odbc (7.3.200). Until now i had
> 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
> 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
> 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.
pgsql-performance by date
|Next:||From: Ron St-Pierre||Date: 2004-08-31 18:11:02|
|Subject: Table UPDATE is too slow|
|Previous:||From: Kroh István||Date: 2004-08-31 17:26:15|
|Subject: odbc/ado problems|