Re: Data Selection Slow From VB 6.0

From: Chris Mair <list(at)1006(dot)org>
To: Mahesh Shinde <mahesh(dot)shinde(at)codecindia(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Data Selection Slow From VB 6.0
Date: 2005-08-17 10:28:16
Message-ID: 1124274496.2651.9.camel@dell.1006.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-performance

> 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.

>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-08-17 12:29:13 Re: Data Selection Slow From VB 6.0
Previous Message Mahesh Shinde 2005-08-17 09:50:45 Data Selection Slow From VB 6.0

Browse pgsql-performance by date

  From Date Subject
Next Message Oliver Jowett 2005-08-17 12:29:13 Re: Data Selection Slow From VB 6.0
Previous Message Mahesh Shinde 2005-08-17 09:50:45 Data Selection Slow From VB 6.0