Re: ONLINE SLOW on HP-9000!
In article <6e19r5$ivv$1@news.xmission.com>, Tim Kelly <Tkelly@svhs.org> writes > >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. > Run your SQL with set explain on and make sure that the relevant indexes are being used. >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 -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care