RE: Informix UC7.41 - slow

Geezer- Processors aren't the only bits of hardware that affect IO performance. What is your bus speed and what types of disks are on the two systems and what is the connection (Fiber Channel, Wide Ultra SCSI, etc.)? A 10,000 RPM disk with a big (say 2 Mb) cache connected by Wide Ultra SCSI on a slow system may very well out perform a fast system with Single Ended SCSI and a 5,000 RPM disk. This is, of course assuming that the two systems are otherwise configured in a similar manner. --EEM > -----Original Message----- > From: Geezer From The Freezer [mailto:Geezer@Freezer.com] > Sent: Tuesday, January 18, 2005 5:12 AM > To: informix-list@iiug.org > Subject: Re: Informix UC7.41 - slow > > > > malcolm weallans wrote: > > > > I would query how you can define that it is running slow when it is a > > test system. I have observed that IDS doesn't really ever start to make > > the most of the resources until you have a reasonable number of users > > doing reasonable work loads. I have production systems that say they're > > running slow and I find out they have 4 users and the cpus are 98% idle. > > They don't benefit from shared memory as they rarely read pages twice > > within a few days. > > I see you say you're using cooked files. Performance and cooked files > > are not commonly seen together. You can spend a lot of time trying to > > tune a test system and it won't bear any relevance to the live system. > > But generally I would suggest reading the Performance Guide manual. Set > > up the system according to that. Then read the cdi archives for all the > > improvements to LRUMIN, LRUMAX. No of LRUS etc. There are no easy > > answers to performance, and as I said before you can't expect good > > performance from a test system. > > > > But if you want to employ a consultant then ..... > > > > Like I said, I have two test systems. One running on a Solaris Ultra 10 > with > 512Mb > RAM and a 440Mhz processor. Restoring data on there is 3 times faster. > On the Blade 1000 with 2 x 750Mhz processors and 2Gb RAM it takes 3 times > longer. > > These systems are only used to restore data and then extract sections of > data > into > XML Format. sending to informix-list