Re: Slow Process

You could try to: 1. Watch what SQL query runs slow - use the "onstat -g sql". 2. Base on the results of "onstat -g sql" you could try to update the statistics/add indexes on tables involved in the slow query. Sometimes this doesn't help, and only the application/query redesign can help. Best Regards, Octav On Thu, Feb 11, 1999 at 07:43:34PM -0800, 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 -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com