Re: ONLINE SLOW on HP-9000!
>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