Re: Informix Performance Issues

Neil Truby said: > > Can you post the query path from one of the long-running queries (use set > explain on;)? > > You should be able safely to increase BUFFERS to, say 800000. > I wonder what effect this has: RESIDENT 4294967295?!! It's the same as setting RESIDENT -1 -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg sending to informix-list