RSWUWFML2 Report

[Stevens, Seth]

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?

Any tips?

Thanks,
Seth



-----------------------------------------
Anadarko Confidentiality Notice:  
This electronic transmission and any attached documents or other
writings are intended only for the person or entity to which it is
addressed and may contain information that is privileged,
confidential or otherwise protected from disclosure.  If you have
received this communication in error, please immediately notify
sender by return e-mail and destroy the communication. Any
disclosure, copying, distribution or the taking of any action
concerning the contents of this communication or any attachments by
anyone other than the named recipient is strictly prohibited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20060807/6fda0e10/attachment.htm