COMMIT points and defer linkpage

[Bob Deskin]

There should be no difference between PowerHouse Web and PowerHouse 4GL. 
And even though the PHWebServer doesn't normally terminate, at the end of 
a page it's at the screen ID prompt, so any pending transactions would be 
committed.

Bob



From:   Peter Bateman <peterbateman808 at hotmail.com>
To:     PowerHouse List <powerh-l at lists.sowder.com>
Date:   2010-11-20 02:43 PM
Subject:        COMMIT points and defer linkpage
Sent by:        powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com




 
Hi all:
 
  I had a phwebserver go nuts yesterday. It was consuming 98% of the CPU 
for 10 minutes.
 The log didn't tell me much.
 The program that was running has a procedure POSTUPDATE with some accepts 
and a defer linkpage in it ( no LOCAL option).
 
 In this scenario when will the UPDATE transaction be commited?
 
 I am temped to place a COMMIT UPDATE just before the accepts just because 
I don't want the transaction open
 while users are entering data.
 
 Another possiblity would be to place the accepts and the defer linkpage 
in a designer procedure and PUSH the
 designer procedure from the POSTUPDATE thus causing the UPDATE 
transaction to commit.
 
Thanks,
Peter
 -- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
list archive at Google.