Re: Informix Performance

akisx@logica.com (Xenophontos Akis) wrote: >We are running a system on a Tandem Non Stop UNIX V5.3 machine with >Informix OnLine V5.05. ... >I think : >After a system reboot the sqlturbo processing time was drastically reduced. >This suggests to me that there is some problem with OnLine, a possible memory >leak which slows the sqlturbo processing over a period of time. So, our only >current solution is a reboot. Have you tried taking the DB off and on line? And, have you tried doing an UPDATE STATUS? These two things may be what you actually need to have happen (the first, unfortunately, is nearly a reboot from the DB perspective). In V. 5, we've found defunct processes hang out from programs that might not cleanly exit (remotes reboot, etc.). Also, if you do a lot of large updates and/or inserts to your tables, you will find that the UPDATE STATUS will cause the indices to be rebuilt, improving performance for indexed operations. Hope that helps. Have fun! - Bob P.S. I think the command is UPDATE STATUS - I'm at home so I don't have manuals at hand. - RLH "I did not ask for the anal probe." -- Passion Fish "Discipline is never an end in itself, only a means to an end." -- King Crimson