Re: Informix Performance Issues
"Anirudh Chitnis via DBMonster.com" <forum@DBMonster.com> wrote in message
news:4d71b87ec26b42cbba3bfa8ae42593e7@DBMonster.com...
> All,
>
> 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.
> 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
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?!!