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 B75D55E3632 for ; Thu, 2 Sep 2004 07:44:45 -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 96045-09 for ; Thu, 2 Sep 2004 10:44:42 +0000 (GMT) Received: from mail2.mail.iol.ie (mail2.mail.iol.ie [193.95.141.54]) by svr1.postgresql.org (Postfix) with ESMTP id 4CF645E4710 for ; Thu, 2 Sep 2004 07:44:40 -0300 (ADT) Received: from dialup0482.ts551.cwt.esat.net ([193.203.141.226] helo=Nimrod) by mail2.mail.iol.ie with esmtp (Exim 3.36 #9) id 1C2p58-00032I-00; Thu, 02 Sep 2004 11:44:42 +0100 From: "Raymond O'Donnell" To: "=?ISO-8859-1?Q?Kroh_Istv=A0n?=" , pgsql-odbc@postgresql.org Date: Thu, 02 Sep 2004 11:46:02 +0100 MIME-Version: 1.0 Subject: Re: odbc/ado problems Message-ID: <413707FA.23200.282B24@localhost> In-reply-to: <005a01c48f7f$9ff8ae70$0102a8c0@pomme001> X-mailer: Pegasus Mail for Windows (4.21c) Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: Quoted-printable Content-description: Mail message body 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: 200409/3 X-Sequence-Number: 4378 On 31 Aug 2004 at 19:26, Kroh Istv=A0n wrote: > 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. I have found instantiating and using the ADO objects directly to be much faster than using the TADOConnection and TADOQuery components that come with Delphi. - This is in web apps where I'd construct the SQL and execute it with the Connection object. --Ray. ------------------------------------------------------------- Raymond O'Donnell http://www.galwaycathedral.org/recitals rod@iol.ie Galway Cathedral Recitals -------------------------------------------------------------