Re: Informix Performance Issues

Anirudh Chitnis via DBMonster.com said: > > I am using 9.30 on HP-UX 11i. The select queries take quite a long tpo > return. The queries are taking index paths and statistics are also > updated. But are they taking the *correct* index paths? I've had this exact problem, possibly even on HPUX, but it turned out that even though the query was using an index, there was a better indexing strategy possible. Dropped one index, created another, and lo! the problem was solved. > When I tried to look in to the I/O activity, I could find that kio is > having maxlen around 16-17. All other things do not have any thing in > maxlen. I am attaching the first few lines of onstat -g ioq and onstat -g > iov outputs and later the onconfig. > RAM on m/c: 8 GB > CPUs : 4 > > Could someone please help me nail down the root cause ? What does onstat -p say? Is this DSS or OLTP? Schema for the tables? Actual SQL? > # Read Ahead Variables > RA_PAGES 8 # Number of pages to attempt to read ahead Try RA_PAGES 16 -- 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