Re: Powerbuilder to Informix - Poor Network Throughput

neal@flash.net wrote: > > In article <31FBAD3C.308E@cyberramp.net>, Greg <greg@cyberramp.net> wrote: > >I work with a Powerbuilder application that talks IP to an Informix > >database across a network. I've noticed that result sets coming to the > >client across the network to the client don't utilize anywhere near the > >available bandwidth. INet is 5.01.WF1 and WJ2. Both behave about the > >same. I don't think ODBC is involved. > > > >Generally, across a very fast hardwired link, I get 2000 to 10000 bytes > >per second throughput, even though an FTP of the same amount of data > >cranks along at 500,000 - 700,000 bytes per second. > > > >I realize FTP will always be faster, but the difference seems > >ridiculous. Has anybody found any good ways to optimize network > >utilization??? > > > >Greg > > Which version of Informix database server and upon which platform > is it running. Certain combos are notoriously slow while others are > superlatively fast when doing client/server over network links. Informix engine is 7.13.UC2 for Solaris 2.4. Server is 2 CPU Sparc 1000E, 60Mhz. Slowest links between my PC and Server is the ethernet drops on both ends. Riding the FDDI backbone in between. There's a *lot* of bandwidth there to use, I just need to figure out how to do it efficiently. I'm going to recheck this today, but I don't think 5.05 + IStar made any significant difference either. Hopefully, I'll also find out this week if PB5.0 helps any.... TIA - appreciate your help. Greg p.s. could you mention some of the combos you've seen that are exceptionally fast/slow...