Re: Data transfer very slow when connected via DSL

Поиск
Список
Период
Сортировка
Искать
От
Rainer Bauer
Тема
Re: Data transfer very slow when connected via DSL
Дата
Msg-id
24rl73d5td717rimunndjnjghfl1pgqojh@4ax.com
Список
Дерево обсуждения
Re: Data transfer very slow when connected via DSL Rainer Bauer <usenet@munnin.com>
Re: Data transfer very slow when connected via DSL "Joshua D. Drake" <jd@commandprompt.com>
I wrote:

>Hello Harald,
>
>>I do not have a solution, but I can confirm the problem :)
>
>At least that rules out any misconfiguration issues :-(

I did a quick test with my application and enabled the ODBC logging.

Fetching the 50 rows takes 12 seconds (without logging 8 seconds) and
examining the log I found what I suspected: the performance is directly
related to the ping time to the server since fetching one tuple requires a
round trip to the server.

Rainer

PS: I wonder why pgAdminIII requires twice the time to retrieve the data.
В списке pgsql-performance по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: Very long SQL strings
От: Dimitri
Дата:
FAQ