Re: Different behaviour 8.02.402/500, i.e. slower? - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Different behaviour 8.02.402/500, i.e. slower?
Date
Msg-id 47167977.40306@tpf.co.jp
Whole thread Raw
In response to Different behaviour 8.02.402/500, i.e. slower?  (Johann Zuschlag <zuschlag2@online.de>)
List 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 by date:

Previous
From: Johann Zuschlag
Date:
Subject: Different behaviour 8.02.402/500, i.e. slower?
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1009575 ] MS QUERY fails for multi table query