COMMIT points and defer linkpage
Peter Bateman
peterbateman808 at hotmail.com
Sat Nov 20 13:39:38 CST 2010
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20101120/1697889a/attachment.html
More information about the powerh-l
mailing list