RE: ONLINE SLOW on HP-9000!
I'm running the same type of platform and number of users. I increased the memory to 128mb and it doesn't solve the problem. I'm also in a situation that I have several machines, so I loaded one with HP-UX 9.04 and Informix 5.x. This machine only has 64mb of memory, and it is faster than the 10.2 and 7.x Informix. I called Tech support, but they wanted money to do an analysis for performance. They however suggested running "Update statistics high for table", which I did. This did help. But, the 9.04 machine still 'kicks-butt'. I too have played with the onconfig file, turning on/off KAIO and increasing buffers, etc. But, none of them seem to make a difference, at least one that is noticeable. The 10.2 and 7.2x just seems to be a 'slug', but I'm still working on it hoping I stumble into something that makes a difference. I'm also looking into 10.x patches, in the hopes there may be some relieve. -----Original Message----- From: leekb@post1.com Sent: Monday, March 09, 1998 4:05 AM To: informix-list@iiug.org Subject: Re: ONLINE SLOW on HP-9000! In article <6dl744$g1u$1@news.xmission.com>, webster@bom-co.in.DHL.COM says... > > >From : x>carlson1@bellsouth.net > To : informix-list@iiug.org > Subject : Re: ONLINE SLOW on HP-9000! > Date : 05/03/98 04:05 > > > Cecilio wrote: > > > > Hi! > > I'm working with: > > - HP-9000 817, 64MB RAM, HP-UX 10.20 > > - Informix ONLINE 7.14 > > - 4GL RDS Application > > - My Database has 200 tables, but only 3 or 4 of them containing more > > than 100,000 rows. > > - 16 simultaneous users. > > > > I think it would work well, but the performance is LOW!!! > > I've tested different changes in the ONCONFIG file without good results. > > I don't know which is the problem: > > - Incorrect HP-UX configuration ? > > - Little memory? (I don't think so) > > - Incorrect ONCONFIG configuration ? > > Well I think you are facing this problem because the memory of your machine > is less. On an average HP-UX O/S 10.20 uses about 18-20MB of RAM. Also > if Informix is running on the machine, each user is assigned about 3MB of > RAM. And as you say that you have 16 simultaneous users working on the > machine which totals to 20 MB+(3Mb*16users) = 68MB. Also for process that > are initiated in the background memory is used. > > > > > Which are the main things about performance? > > > > Someone can help me? > > > > Thanks. > > Webster D'Souza > You should follow a series of steps in tackling such performance problem. What you should do FIRST is pin-pointing the bottleneck. Is it CPU, memory, or I/O? In most cases, CPU is unlikely. So look out for memory and I/O. Nail down the culprit and act accordingly. Good luck! LeeKB