Re: BIG Istar performance problem

Poul Pedersen (pp@q8.dk) wrote: : Subject: BIG Istar performance problem. : ---------------------------------------- : I have a very big performance problem with Istar. : My server is an Data General AViiON 9500 (2 cpu's) with 4 OnLines. I have : 2 Data General clients and 2 Pyramid MIServer clients. : There is also activity between the OnLines on the server (Istar : by usings "local host". : A simple testprogram have been created to measure times for : open database, select etc. : On the server I have 300 to 500 sqlturbo processes. No frontends : runs on the server. All frontends are version 4.10.xx and all : backends are version 5.00.xx. : If I run my test program on the server, when the load is high : without using Istar, the total used time is very low, it may : be 0.07 sec. up to 1.00 sec. : If I run my test program using Istar from the server or from one : of the clients the used time gets very bad, the time peaks up : to 190 sec. Actually it is not useful to run client server : for the normal users ! : Do you have any input that might help me ? : If yes please write a mail. Try making a remote connection over I-Star and then either breaking out of it or just waiting for it to finish. Go over to another terminal and run a netstat and see what your socket is doing. My Pyramid exhibits the same behavior, it holds onto a socket for about 90 seconds after the last info is transmitted. I've traced some bug reports on Informix-Link down to a TCP/IP parameter called SO_LINGER, that seems to tell the socket to remain open for a certain amount of time after the request to close it is given. That's as far as I can get. I'm at my limit of TCP/IP...sockets expertise. We gave up on I-Star and are using our own homebrew tools that work better (and also doesn't require like logging modes on both databases, BTW). Has anyone solved this? : Thanks from: : ----------------------------------------------------------------- : Databaseadministrator Poul Pedersen : Kuwait Petroleum (Danmark) A/S : Hummeltoftevej 49 Mail: pp@q8.dk : 2830 Virum Voice: +45 45 98 45 94 : Denmark Fax: +45 42 85 14 18 : ----------------------------------------------------------------- -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) "If you believe that my statements Database Administrator represent my company, please send The Tigon Corporation money and I'll send you stock" Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Fall '94 from Prentice Hall! ===========================================================================