Re: Delay in commands returning

Posted in 2009

Neil Truby — Fri, 30 Oct 2009 10:51:40 -0000 — source: Usenet: comp.databases.informix

"LIGHT SCANS" <light_scans@yahoo.com> wrote in message news:0ab514e2-51f0-4f5d-8e42-03435920c006@z3g2000prd.googlegroups.com... > Hello Neil, > > I am going to guess that you allocated a large amount of your Sun > M9000's memory to Informix. It may take a second to read all that > memory (or even part of it) to give you an answer. Another guess is > that the many lines of Informix engine code interact with the many > lines of Sun operating system code causing a 1 second delay on a Sun > M9000. This maybe something you will have to live with or require > some Sun tuning. > > Right or wrong, I am very curious of what you will eventually find > out. Plausible theory, and something I hadn't thought of testing. But, I tried it on a small instance, and no difference: time onstat - IBM Informix Dynamic Server Version 10.00.FC9 -- On-Line -- Up 00:01:39 -- 361472 Kbytes real 0m1.025s user 0m0.006s sys 0m0.013s

↪ replying to Neil Truby

Neil Truby — Fri, 30 Oct 2009 11:31:20 -0000 — source: Usenet: comp.databases.informix

I've raised a support call now btw, PMR 80853,001,866 refers.

Glossary

onstat