Powerhouse Quiz takes 60%+ CPU in EXEC mode

[Chris Sharman]

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
______________________________________________________________________
Chris Sharman			Chris.Sharman@CCAgroup.co.uk
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.