[PERFORM] ODBC driver over network very slow

2005-06-30 Thread Milan Sekanina
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 *

Re: [PERFORM] ODBC driver over network very slow

2005-06-30 Thread Tom Lane
Milan Sekanina [EMAIL PROTECTED] writes: 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

Re: [PERFORM] ODBC driver over network very slow

2005-06-30 Thread Merlin Moncure
Milan Sekanina [EMAIL PROTECTED] writes: 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

Re: [PERFORM] ODBC driver over network very slow

2005-06-30 Thread Kevin Grittner
I was hesitant to jump in on this because I am new to PostgreSQL and haven't seen this problem with _it_, but I have seen this with the Sybase database products. You can configure Sybase to disable the Nagle algorithm. If you don't, any query which returns rows too big to fit in their network