Runaway QTP process

[Robert Mills]

Chris,

What's 'PH_sitehook' and what platform is it available on?

regards,
Robert W.Mills (Windsong Services)

-----Original Message-----
From: Chris Sharman [mailto:Chris.Sharman@ccagroup.co.uk]
Sent: Thursday, September 07, 2000 9:25 AM
To: azcognos@anodizing.com
Cc: Chris.Sharman@ccagroup.co.uk; powerh-l@sphere.swau.edu
Subject: RE: Runaway QTP process


>ACC ACK-OPERATIONS LINK A-WORK-ORDER  TO &
>                                A-WORK-ORDER OF ACK-DIE-ITEM
>
>SELECT ACK-DIE-ITEM IF ITEM-NUM OF ACK-OPERATIONS = &
>                       ITEM-NUM OF ACK-DIE-ITEM AND &
>                       DELETE-CODE OF ACK-DIE-ITEM <> ' '
>
>OUTPUT ACK-OPERATIONS UPDATE
>ITEM DELETE-CODE OF ACK-OPERATIONS FINAL DELETE-CODE OF ACK-DIE-ITEM

I'd be inclined to add a 'sorted at', and make the update 'update at', to
have
a control break once per ack-operations record, if there can be multiple
ack-die-item records to one ack-operations record, otherwise I think QTP
would
fail in the output phase with 'record has changed since you found it'.

All the ADT products can be CPU hogs: we use PH_sitehook to guarantee Quiz &
QTP runs at lower priority, and 'do external' to adjust the priority on a
Quick
screen before 'hogging' (typically a select across a whole file).
Performance can be an order of magnitude or so worse than a 3GL: that's the
nature of a 4GL, & the price we pay for the easier programming.

A Quiz pre-pass, as you've done, is probably a preferable solution, if it
gets
acceptable performance. QTP has to use an intermediate file for the above,
and
has much higher overheads (locking, checking) than Quiz.
_______________________________________________________________________
Chris.Sharman@CCAgroup.co.uk		http://www.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
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.