X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 212A5D1E2CD; Mon, 5 Apr 2004 12:56:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 41548-09; Mon, 5 Apr 2004 09:57:03 -0300 (ADT) Received: from hotmail.com (bay8-f28.bay8.hotmail.com [64.4.27.28]) by svr1.postgresql.org (Postfix) with ESMTP id A94DFD1E2C2; Mon, 5 Apr 2004 09:56:33 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 5 Apr 2004 05:57:10 -0700 Received: from 69.65.137.210 by by8fd.bay8.hotmail.msn.com with HTTP; Mon, 05 Apr 2004 12:57:09 GMT X-Originating-IP: [69.65.137.210] X-Originating-Email: [el_vigia_ec@hotmail.com] X-Sender: el_vigia_ec@hotmail.com From: "Jaime Casanova" To: psql-odbc@postgresql.org, pgsql-admin@postgresql.org Subject: [ODBC] psqlodbc problem? Date: Mon, 05 Apr 2004 12:57:09 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 05 Apr 2004 12:57:10.0149 (UTC) FILETIME=[81EC5350:01C41B0D] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/41 X-Sequence-Number: 13014 Hi all, i'm having a problem when connect vb6 with pgsql-7.3.1 using the psqlodbc. i have a simple select (select * from mytable where pkey = 1;) in a 6 row table, when i explain analize it give me 63ms (milliseconds). but there are 13 seconds between i order de execution of the select and it give me the results. maybe aproblem of the odbc, if yes what solution can be. thanx in advance, Jaime Casanova _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail