Re: Big ISTAR performance problem

Poul Pedersen writes: [Stuff deleted] |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. It may help to get the exact versions of both Online and Istar for each machine/environment - we have had problems in the past when they are not exactly the same. We also had almost exactly the same problem with version 5.01.xx, but this was caused by the license daemon. Perhaps you could try the same thing out with a different version of Informix (eg: 5.02 if available) and see if the performance is still bad - you could do this separately from your live stuff first. |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 ! What sort of things is your test program doing ? Could you let us have a copy of the program and test script ? Hope this helps, Richard Ridley