Re: Powerbuilder to Informix - Poor Network Throughput

Nils... FWIW, here's what I have discovered so far. Part of the problem is the technique for retrieving rows in the Powerscript code. Our trusty application developers just got done changing all the (now slow) code to use dynamic cursors, rather than data windows. Major mistake...data windows are 6-7 times faster. Now they get to change it all back... I'm starting to catch wind of a means to increase a INet parameter called FET_BUF_SIZE that has something to do with the negotiated window size, don't know yet if that will produce any benefit though. I'll post if there's anything juicy though. We're also going to try OpenLink too, i'll post if that's interesting as well.... Greg Nils Myklebust wrote: > snip.... > It would have been very interesting if you could have done a trial > with the OpenLink ODBC drivers though. From other reports they seem to > be faster than "native" drivers. The "native" drivers using I-Net will > go through at least as many layers of functioncalls in DLL's as the > best ODBC-drivers do (that do not use I-Net). > > If it's too hard to change your PB programs to use ODBC may be you > could make a small and simple test program to measure performance (on > blobs as well as the character data you have problems with). > > A real life report on the results would be more than interesting. > > You can download a free trial version from www.openlinksw.com > snip...