Powerhouse Quiz takes 60%+ CPU in EXEC mode

[Richard Witkopp]

> OpenVMS Alpha 7.1, RMS, Cognos Powerhouse 7.10.G1 Quiz.
> 
> Some of our Quiz reports are CPU intensive, which is mildly 
> surprising: I'd
> have expected a reporting tool to be I/O intensive, but then 
> it's a 4GL.
> 
> We get around this by dropping the priority on the fly for 
> interactive Quiz &
> QTP users (using PH_SITEHOOK). We can see 90%+ CPU usage on a 
> single Quiz user.
> 
> Even more surprising, it appears to be predominantly (60%+) 
> EXEC mode (ie RMS
> execution - no database present).
> 
> I've no idea how I'd go about making RMS use so much CPU 
> without thrashing the
> disk. Is this reasonable, or is Quiz re-reading the same 
> record lots of times
> so that RMS can optimise away the disk access, or mis-tuned 
> files, or what ?
> 
> Any suggestions for tuning, debugging, or further diagnosis 
> would be greatly
> appreciated.
> 
> Thanks,
> Chris Sharman

I imagine you've already done the standard RMS tuning stuff.
Just grasping at straws, but one thing you might check is the index
bucket sizes. Sometimes, if they are sized to result in hundreds of
index entries you get some churning because of the way RMS does
binary searches of the index buckets.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.