From: Milan Sekanina <milan@sde.cz>
To: pgsql-performance@postgresql.org
Subject: ODBC driver over network very slow
Date: Thu, 30 Jun 2005 12:28:55 +0200
Message-ID: <42C3C967.8060605@sde.cz> (raw)
We are running an application that uses psqlodbc driver on Windows XP to
connect to a server and for some reason the download of data from the
server is very slow. We have created a very simple test application that
inserts a larger amount of data into the database and uses a simple
"SELECT * from test" to download it back. The INSERT of 10MB takes about
4 seconds, while the SELECT takes almost 5 minutes (with basically
nothing else running on both the network and the two computers). If we
run the PostgreSQL server on the local machine so that the network is
not used, both actions are very fast.
Do you have any idea what could be the cause of this behavior? Are there
any driver settings/other drivers we should use? We are currently using
psqlodbc version 7.03.02.00, but it seems that other versions we tried
show the same behavior. We have tweaked the various driver settings but
the times remain basically unchanged.
Any ideas or hints are warmly welcome.
regards
Milan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: milan@sde.cz
Subject: Re: ODBC driver over network very slow
In-Reply-To: <42C3C967.8060605@sde.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox