Slow Visual Basic application

From: "Cecilia Alvarez" <cecilia_ag(at)hotmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Slow Visual Basic application
Date: 2003-04-10 17:32:49
Message-ID: F85zfoV1qdiixjnzi950000005a@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<html><div style='background-color:'><DIV>Hi,</DIV>
<DIV>I have a visual basic application and the access to postgress is&nbsp;very slow.</DIV>
<DIV>If I run the query on PGadminII the answer is quite&nbsp;good but if I run the same query&nbsp;from the application it takes a long time (I debugged it). 11seconds .vs. 5 minutes.</DIV>
<DIV>I would like to know if I have a problem with my connection to postgres or my odbc.</DIV>
<DIV>The string connection is:</DIV>
<DIV>&nbsp;</DIV>
<DIV>gobjBD.StringConexion = "Provider=MSDataShape.1;DRIVER={PostgreSQL};DATABASE=mydatabase;<BR>SERVER=192.9.200.5;PORT=5432;UID=postgres;PWD="</DIV>
<DIV>&nbsp;</DIV>
<DIV>I´ll really apreciate your help.</DIV>
<DIV>Thanks</DIV>
<DIV>Cecilia</DIV></div><br clear=all><hr>Únete al mayor servicio mundial de correo electrónico: <a href="http://g.msn.com/8HMJESMX/2755">Haz clic aquí </a> </html>

Attachment Content-Type Size
unknown_filename text/html 884 bytes

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Chris Hedemark 2003-04-10 17:47:44 Re: Reference data for performance testing?
Previous Message Boris Popov 2003-04-10 17:24:51 Re: Reference data for performance testing?