Thread: 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
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