Re: 500 times slower

Поиск
Список
Период
Сортировка
От Karol Szkudlarek
Тема Re: 500 times slower
Дата
Msg-id 4209F88A.8060200@mikronika.com.pl
обсуждение исходный текст
Ответ на Re: 500 times slower  (Karol Szkudlarek <karol@mikronika.com.pl>)
Список pgsql-odbc
Karol Szkudlarek wrote:
>
> The problem exists only between windows client and remote windows
> server. The other configurations (for example remote linux server)
> works ok. We are using stable version of psqlodbc driver.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

Hi!

My collegue spent some time to dig the following case and it looks like
Nagle algorithm and delayed ACKs related problem.
In psqlodbc.h
#define SOCK_BUFFER_SIZE            4096

I changed that value to 8192 and driver works fine for me.
I am not sure why this change helps.

Karol

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: queries run twice unless 'parse statements' checked?
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: 500 times slower