TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through ODBC)

Hi list

This is a follow-up to
http://archives.postgresql.org/pgsql-odbc/2006-02/msg00067.p hp

Let me sum up the problem :
I run a query in pgadmin into a file (to be sure that all data is
transfered). It runs very fast (in about 10sec), and data is
transfered from the server at a very fast rate (~1MB per second).
I run the same query via psqlodbc in a VBA application. It takes
ages to run and data is transfered at a very slow pace (~80kB per
second).

The query returns the WKT representation of a geometry, so it
returns a very long varchar field.
Last time we discussed this problem, we thought the problem was
with TCP_NO_DELAY.
We hadn't found out why the TCP/IP stack behaved differently in
pgadmin and in psqlodbc.

I am still experiencing this behaviour, even though I installed
postgresql on a brand new server, and my workstation was also just
reinstalled.
Since the problem is still there, I'd like to know if newer
versions of psqlodbc could have changed things.
I am still using the latest official releases (8.01.0200), but
maybe there are beta release I could try ?

Any help would be greatly appreciated !

Thanks a lot
--
Arnaud



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: TCP_NO_DELAY & TcpAckFrequency (Re: Slow query through ODBC)

> I am still experiencing this behaviour, even though I installed
> postgresql on a brand new server, and my workstation was also just
> reinstalled.
> Since the problem is still there, I'd like to know if newer
> versions of psqlodbc could have changed things.
> I am still using the latest official releases (8.01.0200), but
> maybe there are beta release I could try ?

There is new version 08.02.0002 on pgfoundry.org. And in bug
entry BiDiMode* you can find the URL for the latest .dll
files located at Hiroshi pages.
The 08.02 version is based on 07.03 - not 08.01 so it could helps you.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly