Re: Slow Process

Check out the NOAGE parameter. it should be set to 1 (may be that's why it slows down as time goes). Don Semmens wrote: > Informix 7.30 > Hp 9000 unix > 4 Proc. > 1 gig RAM > 2 db instances of 14 gig each (approx.) > Application: Elite Legal Billing System > Process: Proforma Generation > > We recently upgraded from 5.10 to 7.30. Everything is running > smoothly with the exception of "proforma" generation (reports > of all unbilled time and costs). This process queries the biggest > tables in the db. > > The usual procedure is for us to queue up 8-10 of these processes > for our different office locations. Before the upgrade, 90% of > these would be completed within 9 hours. After the upgrade the > bigger offices took an incredible amount of time to complete and > some of them never did. Symptom: Process starts out generating > very quickly (a count is displayed), but as the process continues it > gets slower and slower (smaller offices do finish in a timely > manner). We ended up stopping the process, then starting it again > from where it left off. The same symptom would be exhibited. > > At first we thought this might be caused by swapping (2 instances > are eating up most of our RAM), but even after rebooting, running > only one instance, and only running one process, the same symptom > has occurred. > > We've played around a bit with PDQ, but that has helped very little. > > The same symptom is exhibited on both instances (the 2nd instance > is a "history" db as of 12/1998). > > We have also performed a tbcheck -cI on the history db without any > problems. > > We will be adding another gig of RAM and a new version of the > application (2.5d) and I'm hoping against hope that this may > help. > > Any other suggestions would be appreciated. Also, if anyone else > running Elite has had this problem, I'd love to know how it was > resolved. > > Oh, on an unrelated (maybe) subject: Are oninit processes > supposed to build up a lot of time (1453 seconds over a couple days)? > That was something that sort of jumped out at me, but the Informix > guy at Elite said it was ok. > > Don Semmens > Richmond, VA > h -- donsem@concentric.net w -- dasemmen@mwbb.com > > -- > Come senators, congressmen, do what is best > And don't try to act like you've never had sex > You're pompous, self-riteous [sic] and boring at best > And our patience is rapidly fading -- Arturo Rodr'guez Mutis Director de Inform'tica Melexa Ltda. PBX (571) 360 3055 FAX (571) 360 2562 e-mail melexa@colomsat.net.co