Re: Informix 7.25 SE on Digital Unix 5.1

Hmmm, I admit a little red faced I forgot about it. There is cron that does it everyday on the old machine. Now with statistics updated it works fine on the new one. We had so much problems with C2 security with this version that we forgot to do the basic things. Thanks a lot for pointing me to such naive mistake Carlos Clive Eisen <clive@serendipita.com> wrote in message news:<40bef891$0$4593$db0fefd9@news.zen.co.uk>... > Carlos Alonso wrote: > > Hi all, > > > > We testing in order to migrate to Informix 7.25 SE (yes, a bit old) > > on a Dec Tru64 5.1 and found some performance issues. The previuos > > instante was running in a DecUnix 4.0d with Informix 7.24 SE in a less > > powerful machine. > > > > Testing the same query on both boxes, in the 7.25-Tru5.1 one it takes > > about 20 secs to complete and in the old one results are almost > > inmediate. DB has been imported from unload recently and should have > > no degradation. > > > > We have some issues with 7.25 and C2 security and seemed to be > > resolved, turning it off for informix user. We have no idea of what > > can be causing this delay. No disk bottleneck is found (no I/O traffic > > or swapping) The only strange thing is that kernel activity raises > > more (20% or so) than the old version on 4.0d > > > > Any ideas for this performance issue? > > > > Regards > > > > Carlos > Have you updated statistics after the load > > post the results of set explain on from the old and the new