Postgres Pro
Downloads
Home   >   mailing lists

Re: Data Selection Slow From VB 6.0 - Mailing list pgsql-performance

From Chris Mair
Subject Re: Data Selection Slow From VB 6.0
Date
Msg-id 1124274496.2651.9.camel@dell.1006.org
Whole thread Raw
In response to Data Selection Slow From VB 6.0  ("Mahesh Shinde" <mahesh.shinde@codecindia.com>)
List pgsql-performance
Tree view 

> When I fire a query to search a debtor id,  it took around 5 seconds
> to return an answer for a query [...]

Are you sure that time is actually spent in the database engine?
Maybe there are DNS resolving issues or something...

Did you try to execute the queries directly on the server from
the psql shell?

Bye, Chris.


>

pgsql-performance by date:

Previous
From: "Mahesh Shinde"
Date:
Subject: Data Selection Slow From VB 6.0
Next
From: Dave Cramer
Date:
Subject: Re: [JDBC] Performance problem using V3 protocol in jdbc driver