Re: Informix UC7.41 - slow

Geezer From The Freezer wrote: > > "Art S. Kagel" wrote: > >>Geezer From The Freezer wrote: >> >>>TBP wrote: >>> >>> >>>>Geezer From The Freezer wrote: >>>> >>>> >>>>>Hi, >>>>> >>>>>My Informix installation seems to be running quite slowly. It's running on a Sun >>>>>Blade >>>>>1000 with 2 x 750Mhz processors and 2Gb RAM. >>>>> >>>>>Here is the onconfig file - anything obviously wrong or tuneable? >>>> >>>>Yes :D >>>> >>>>No such version as UC7.41, but presumably this is something like 7.31.UC7?? >>> >>> >>>oops. 7.31.UC5 even, my mistake :D >> >>OK, you're on the right track now. Repost your ONCONFIG info (so we don't >>have to hunt down the original post) along with ALL of the following and >>someone will help: >> >>Time since startup or since onstat -z was run if later. Output from: >>onstat -p >>onstat -d >>onstat -P >>onstat -D >>onstat -m >>onstat -F >>onstat -g glo >>onstat -g iov >>onstat -g iof >>onstat -g rea>> >>Art S. Kagel > > > ok ran onstat -z to remove stuff - ran some simple export commands from the > application running > over informix. Here is more info - > <snip> Well, I don't think that running onstat -z and then doing 2 exports will provide statistics which are relevant to your "normal running" - perhaps do an onstat -z, let it run for a day(??), and then post the output. It is good that you re-posted your onconfig - 'cos it changed :D I would still reduce NUMAIOVPs tho'.

TBP wrote: > > Well, I don't think that running onstat -z and then doing 2 exports will > provide statistics which are relevant to your "normal running" - > perhaps do an onstat -z, let it run for a day(??), and then post the output. > > It is good that you re-posted your onconfig - 'cos it changed :D > > I would still reduce NUMAIOVPs tho'. Like I said this is a test system and is only being used to restore data to it and then export that data as XML! Its not used for anything else.