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 C288B5E46EE for ; Wed, 1 Sep 2004 05:33:10 -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 62113-04 for ; Wed, 1 Sep 2004 08:33:06 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id C1A595E46F9 for ; Wed, 1 Sep 2004 05:33:05 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i818X2Lq063011 for ; Wed, 1 Sep 2004 08:33:02 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i818JqVw058197 for pgsql-odbc@postgresql.org; Wed, 1 Sep 2004 08:19:52 GMT From: "Markus Donath" X-Newsgroups: comp.databases.postgresql.interfaces.odbc Subject: Re: odbc/ado problems Date: Wed, 1 Sep 2004 10:19:48 +0200 Organization: Hub.Org Networking Services Lines: 46 Message-ID: References: <005a01c48f7f$9ff8ae70$0102a8c0@pomme001> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 To: pgsql-odbc@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=PRIORITY_NO_NAME X-Spam-Level: X-Archive-Number: 200409/1 X-Sequence-Number: 4376 hello, did you use a read only / forward only cursor (adOpenForwardOnly) ? this is the fastest way to retreive data, other cursor types are much slower with postgres odbc. bye, Markus Donath. "Kroh István" schrieb im Newsbeitrag news:005a01c48f7f$9ff8ae70$0102a8c0@pomme001... > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >