<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.28">
<TITLE>RSWUWFML2 Report</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi all…does any one have any performance suggestions for the RSWUSFML2 report for workitem notification? It is currently taking over 3 hours to run and is increasing at a rate of about 10 minutes per day. I'm sure that archiving the workitems and logs would help but I didn't want to do that yet as the system has been in production for less than 1 month. Is the architecture of the report such that the response time is affected by all workitems (even completed) or is it only affected by the number of in process workitems?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Any tips?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks,</FONT>
<BR><FONT SIZE=2 FACE="Arial">Seth</FONT>
</P>
</BODY>
</HTML>
<HTML><BODY><P><hr size=1></P><br>
<P><STRONG><br>
Anadarko Confidentiality Notice: <br>
This electronic transmission and any attached documents or other<br>
writings are intended only for the person or entity to which it is<br>
addressed and may contain information that is privileged,<br>
confidential or otherwise protected from disclosure. If you have<br>
received this communication in error, please immediately notify<br>
sender by return e-mail and destroy the communication. Any<br>
disclosure, copying, distribution or the taking of any action<br>
concerning the contents of this communication or any attachments by<br>
anyone other than the named recipient is strictly prohibited.<br>
</STRONG></P></BODY></HTML>