Re: Powerbuilder to Informix - Poor Network Throughput

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