Re: Powerbuilder to Informix - Poor Network Throughput

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