X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2AFD65E46D4 for ; Tue, 31 Aug 2004 14:26:53 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88801-07 for ; Tue, 31 Aug 2004 17:26:47 +0000 (GMT) Received: from mail.tvnetwork.hu (zion.tvnetwork.hu [80.95.64.67]) by svr1.postgresql.org (Postfix) with SMTP id D88DA5E46CC for ; Tue, 31 Aug 2004 14:26:45 -0300 (ADT) Received: (qmail 16224 invoked by uid 64014); 31 Aug 2004 17:26:41 -0000 Received: from istvan.kroh@pomme.hu by zion by uid 64011 with qmail-scanner-1.20rc3 (clamuko: 0.60. spamassassin: 2.60. Clear:RC:1:SA:0(0.0/5.0):. Processed in 0.195051 secs); 31 Aug 2004 17:26:41 -0000 Received: from unknown (HELO pomme001) (80.95.83.31) by zion.tvnetwork.hu with SMTP; 31 Aug 2004 17:26:41 -0000 Message-ID: <005a01c48f7f$9ff8ae70$0102a8c0@pomme001> From: =?iso-8859-2?Q?Kroh_Istv=E1n?= To: , Subject: odbc/ado problems Date: Tue, 31 Aug 2004 19:26:15 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/66 X-Sequence-Number: 4375 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