From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Johann Zuschlag <zuschlag2(at)online(dot)de> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Different behaviour 8.02.402/500, i.e. slower? |
Date: | 2007-10-17 21:07:03 |
Message-ID: | 47167977.40306@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2007-10-19 18:15:21 | [ psqlodbc-Bugs-1009575 ] MS QUERY fails for multi table query |
Previous Message | Johann Zuschlag | 2007-10-17 15:17:25 | Different behaviour 8.02.402/500, i.e. slower? |