Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: unknown_filename
Description: text/html (884 bytes)

Responses

pgsql-performance by date

Next:From: Chris HedemarkDate: 2003-04-10 17:47:44
Subject: Re: Reference data for performance testing?
Previous:From: Boris PopovDate: 2003-04-10 17:24:51
Subject: Re: Reference data for performance testing?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group