Re: Powerbuilder to Informix - Poor Network Throughput

In article <4tq0vk$n1j@bull.hkstar.net>, siumk@b1.hkstar.com (Mak Siu Kei) wrote: >Chao Y. Din (cdin@csc.com) wrote: >: Greg 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 > >: I don't think either Powerbuilder or Informix causes the performance >: problem. We are currently using Powerbuilder and Informix for IMAGE >: applications. The average image size is about 60-100KByte, and we are >: running token ring with 16MBit. The response time to retrieve and >: display an image is something like half a second with 20 active users. > >: It did happen a few time before that the system was slow. But it alwarys >: turned out that the network has problem. You can do the following test >: to see whether your problem is network related. Enter the following two >: commands: > >: arp -a >: netstat -r > >: If the response to any of the above commands is slow, you have network >: problem. If it is not network related issue, I believe you need to check >: both the client and server configuration. > >: Chao > >I believe there is a parameter which could change your network buffer size. >The parameter is in sqlhost and at the end of each line. > >Hope this help ! > > >All the best, > >Alan >-- > > [ Alan Mak Siu Kei ** siumk@hkstar.com ** (852)71286683 ] > > ^ ^ > "Life is more than food, and the body more than clothes." > o o > > ---- < -Luke 12:23 >