Re: Cursor Stability Isolation Level

In article <5op4g8$5uo@cssun.mathcs.emory.edu>, Dianne Pendleton <dianne.pendleton@autodesk.com> writes >I'd like to add my recent experiences with cursor stability, not regarding >locks, but from a performance perspective. > >We have an application written in PowerBuilder 4/5 running on OnLine 7.11, >HP-UX 10.01, in the U.S. (It also ran on a Sequent with OnLine 6.0. for >the history of this problem.) While local performance was acceptable, >performance to places like Australia, Singapore, etc. was not. We ran >sniffer tests on the network and found that the packets were not being >filled. The size available was 4096 bytes, but we often saw only 100 bytes >(or so) in the packets. Blame was placed on INET while others suspected >the application. Finally, Informix let us use their SQLIDEBUG tool which >gathers much more information than a sniffer can. I was able to see that before you ask I have sent an e-mail asking how this works... I feel an undocumented Informix FAQ coming on... -- David Williams