Slow Process

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