Postgres Pro
Downloads
Home   >   mailing lists

1-2 second delay on all commands over network - Mailing list pgsql-novice

From chameenz@yahoo.com (Matthew Cimino)
Subject 1-2 second delay on all commands over network
Date
Msg-id c1cda790.0310311206.4204ab1a@posting.google.com
Whole thread Raw
Responses Re: 1-2 second delay on all commands over network  (Andrew McMillan <andrew@catalyst.net.nz>)
List pgsql-novice
Tree view 
I am coding a small Visual Basic app using ODBC and ADO to connect to
a Postgres 7.3 database running on a RedHat 9 server. The issue I am
having is a small delay of 1-2 seconds for every command I issue in
the application. 2 seconds to connect then 2 seconds to query...about
2 seconds with every command. The app has a few simple queries when it
starts but takes a solid 10 seconds to first open because of these
delays.

The server is already being using as a web server and the speeds on
the queries that PHP makes is great.

Any suggestions would be greatly appreciated.

pgsql-novice by date:

Previous
From: "MaFa"
Date:
Subject: Update cursor - current of
Next
From: Cath Lawrence
Date:
Subject: SQL question