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

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.

Settings are: "Use Declare Fetch" (100), "Updatable Cursors", " Row
Versioning" and "Server Side Prepare"

Regards,

Johann


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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

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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org