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

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

In response to

Browse pgsql-odbc by date

  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?