Powerhouse Quiz takes 60%+ CPU in EXEC mode

[Chris Sharman]

>Check the number of defines; if its more than a dozen or so, check the select
>statement; if you are selecting relatively few records from a large database
>remember that defines are evaluated BEFORE the select statement... then split
>the report into two passes - one to select the data required and write it to a
>subfile, the second to pick up the subfile, link to data not needed for
>selection, and evaluate the defines.
>
>IMHO this is one of the major ways of increasing Quiz/QTP performance.

Interesting tip, thanks. I'd have thought Cognos ought to address that one, in
the same way they don't read more records than necessary before rejecting a
record complex.

But everyone's missing part of my point: Quiz & QTP may be CPU hungry, but they
run in USER mode (I hope). I'm seeing a big hit in EXEC mode, and relatively
modest USER mode demand. This suggests it's RMS itself being CPU bound, which
I find very difficult to fathom.
______________________________________________________________________
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.