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