Re: setnet32 Performance Question

A couple of things to check: o We have noticed that some front-end tools, like SQLWindows, creates temporary files. After a period of time, these files can grow in number which in turns slows down even a basic SELECT. We clean these tmp files up on each reboot of our machines. o You can also tune the packet size through FET_BUFF_SIZE. I believe the default size is 4k. Fred Prose wrote: > Are there any tuning parameters for setnet32? > > Were are using setnet32 on NT workstations to interface powerbuilder to > Informix 7.22 through onsoctcp. Response/throughput is less than desirable. > Running the same SQL statements through DBACCESS provides the (sub-second) > response time we had expected, so actual db design and performance doesn't > appear to be the issue. The network is "coasting" and the terminal > emulation to DBACCESS is "snappy". > > Powerbuilder folks at Sybase have been no help (duh!). > > Suggestions as to where to start?