Re: Different behaviour 8.02.402/500, i.e. slower?

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Different behaviour 8.02.402/500, i.e. slower?
Дата
Msg-id 47167977.40306@tpf.co.jp
обсуждение исходный текст
Ответ на Different behaviour 8.02.402/500, i.e. slower?  (Johann Zuschlag <zuschlag2@online.de>)
Список pgsql-odbc
Johann Zuschlag wrote:
> Hi,
>
> after updating from psqlodbc 8.02.402 to 500 I found a different
> behaviour. Selects seem somehow slower, the server (8.1.9, Windows XP)
> seems to do a lot of work sometimes. I tried to debug using mylog.log.
> There are certain differences doing *exactly* the same query's.
> Unfortunately it is difficult for me to interpret these differences.
>
> Comparing both logs I found the sequence:
> ---
> read -1, global_socket_buffersize=4096
> Lasterror=10035
> read xxxx, global_socket_buffersize=4096
> ---
> (xxxx changing value)
>
> - 7 times using version 402
> - 32 time using version 500
>
> The sequence:
> ---
> QResult: enter DESTRUCTOR
> QResult: in QR_close_result
> QResult: free memory in, fcount=0
> QResult: free memory out
> QResult: enter DESTRUCTOR
> QResult: exit close_result
> QResult: exit DESTRUCTOR"
> ---
> is called more often in 500 or at least at different times.
>
> Version 501 doesn't change anything. Changing back to 402 my app runs
> smooth and fast. Can somebody shed some light on this issue? The mylogs
> (large, 3Mbyte) for both identical tests are available.

Could you send me the mylogs diretly ?

regards,
Hiroshi Inoue


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

Предыдущее
От: Johann Zuschlag
Дата:
Сообщение: Different behaviour 8.02.402/500, i.e. slower?
Следующее
От:
Дата:
Сообщение: [ psqlodbc-Bugs-1009575 ] MS QUERY fails for multi table query