X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B397B476323 for ; Thu, 10 Apr 2003 13:35:29 -0400 (EDT) Received: from hotmail.com (f85.law12.hotmail.com [64.4.19.85]) by postgresql.org (Postfix) with ESMTP id 03454476305 for ; Thu, 10 Apr 2003 13:35:25 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 10 Apr 2003 10:32:49 -0700 Received: from 200.67.80.182 by lw12fd.law12.hotmail.msn.com with HTTP; Thu, 10 Apr 2003 17:32:49 GMT X-Originating-IP: [200.67.80.182] X-Originating-Email: [cecilia_ag@hotmail.com] From: "Cecilia Alvarez" To: pgsql-performance@postgresql.org Subject: Slow Visual Basic application Date: Thu, 10 Apr 2003 12:32:49 -0500 Mime-Version: 1.0 Content-Type: text/html; charset=iso-8859-1 Message-ID: X-OriginalArrivalTime: 10 Apr 2003 17:32:49.0499 (UTC) FILETIME=[35051AB0:01C2FF87] X-Spam-Status: No, hits=0.0 required=5.0 tests=BAYES_30,HTML_20_30 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/115 X-Sequence-Number: 1621
Hi,
I have a visual basic application and the access to postgress is very slow.
If I run the query on PGadminII the answer is quite good but if I run the same query from the application it takes a long time (I debugged it). 11seconds .vs. 5 minutes.
I would like to know if I have a problem with my connection to postgres or my odbc.
The string connection is:
 
gobjBD.StringConexion = "Provider=MSDataShape.1;DRIVER={PostgreSQL};DATABASE=mydatabase;
SERVER=192.9.200.5;PORT=5432;UID=postgres;PWD="
 
I´ll really apreciate your help.
Thanks
Cecilia


Únete al mayor servicio mundial de correo electrónico: Haz clic aquí