Re: Powerbuilder to Informix - Poor Network Throughput

We largely use Inet 5.01.WF1 for the same reasons you do. I just got an eval copy of 5.01.WJ1 or 2 I believe. I'll post if I have any problems with it. It looks ok after a cursory once over.... We do have SymBEL, have only used it a little so far, but will use it among several other ideas we have. As I mentioned, its the dull, old, boring character result sets that are slow as slugs. The one case where we select big BLOBS works pretty well. Our environment of PB4, Inet 5.01.WF1 and online 7.13 is about as straightforward as C/S gets. We're going to see if PB5 makes any difference maybe this week. In a couple of weeks some really sexy sniffer hardware should be available, hopefully it will help. As for FDDI's fixed bandwidth, well, I can usually be happy being fixed at 100 MBits per second. It's this fixed 28.8 KBps that annoys me....;-) Thanks for taking an interest...gm. Chao Y. Din wrote: snip.... > Greg - I did not mean you are not serious about this problem. I meant performance tuning in general. We had serious performance problem in the past. After > we installed SymBEL and followed the suggested settings, the execution time of one of the stored procedure was reduced from 12 hours to 10 minutes on Sparc > 2000E. > > We also had a stored procedure that issued serveral SYSTEM commands in a loop. We then combined those SYSTEM commands into a single one. That made a big > difference. > > Currently, we are working on the performance tuning for another stored procedure to cope with the notorious NFS performance problem. > > How about the INET version number? We had problem with INET 5.X.WF2 and switched back to WF1 because memory leakage problem. But the leakage problem still > exist. WH revision supposes to fix the problem, but it has not been released (I believe). There is another INET problem that may disconnect your > application, but it should have nothing to do with your problem. > > Anyway, I will be glad to know your solution to the problem. > > > > > p.s. if you've had specific problems unique to FDDI, i'd be interested in the specifics... > > I don't have any specific problem with FDDI. It is just a general comment on FDDI, since FDDI's bandwidth is fixed. > > Chao