<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<BR> <BR>
<DIV id=SkyDrivePlaceholder>Hi all:</DIV>
<DIV> </DIV>
<DIV> I had a phwebserver go nuts yesterday. It was consuming 98% of the CPU for 10 minutes.</DIV>
<DIV> The log didn't tell me much.</DIV>
<DIV> The program that was running has a procedure POSTUPDATE with some accepts and a defer linkpage in it ( no LOCAL option).</DIV>
<DIV> </DIV>
<DIV> In this scenario when will the UPDATE transaction be commited?</DIV>
<DIV> </DIV>
<DIV> I am temped to place a COMMIT UPDATE just before the accepts just because I don't want the transaction open</DIV>
<DIV> while users are entering data.</DIV>
<DIV> </DIV>
<DIV> Another possiblity would be to place the accepts and the defer linkpage in a designer procedure and PUSH the</DIV>
<DIV> designer procedure from the POSTUPDATE thus causing the UPDATE transaction to commit.</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>Peter</DIV>
<DIV> </DIV> </body>
</html>