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

From: Johann Zuschlag <zuschlag2(at)online(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Different behaviour 8.02.402/500, i.e. slower?
Date: 2007-10-17 15:17:25
Message-ID: 47162785.4090700@online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2007-10-17 21:07:03 Re: Different behaviour 8.02.402/500, i.e. slower?
Previous Message Stephen Frost 2007-10-15 19:37:33 Failed PW retries