RE: IDS 10 erratic run times

Neil, There is at least one reason why subsequent attempts to 'dbimport' without re-initializing the server with 'oninit -i' is slower the first one: when Informix engine is using pages that were 'clean' it is not trying to put images in the physical log. Moreover, it doesn't even need to read the page from disk before updating it. What is really strange, is 'update statistics' slowness. One possible reason is that indexes became mo fragmented... Did you drop the database before re-import or just renamed it? Did you make 'oninit -i'? -Alexey > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On > Behalf Of Neil Truby > "scottishpoet" <dryburghj@yahoo.com> wrote in message > news:1127128089.906988.42210@g43g2000cwa.googlegroups.com... > > Neil, > > > > I have seen anything similar when we had AUTORAID configured on a > > system > > > > Sometimes the disks ran as RAID 10 and other times as RAID 5 depending > > how the AUTORAID decided to configure them > > > > > > When RAID 10 the performance was great > > > > When RAID 5 our perfromance was woeful > > > > Interesting. I'm sure this is a permanent RAID 0+1. And the performance is > not exactly consistently slow, more stop-start. I will check this out. > > At the moment the situation is to vague to raise a support call with IBM, > and it has to date resisted my attempts to reproduce a smaller case. We're > continuing to try to build a reproducible case, and see it's just a 10.0 > thing (no reason to believe is it at this point). I've had a few cases in > the past couple of years when we've painstakingly built a case then been > told almost immediately by IBM we've hit a known problem. How I wish there > was still the facility of TechInfo, where we mortals can check this out for > ourselves at the outset. > > If anyone from Tech Support is reading, could I ask them if there are any > known bugs in IDS 10.0 consistent with our symptoms? > > thanks > Neil sending to informix-list