<br><font size=2 face="sans-serif">Hi Ritapac,</font>
<br>
<br><font size=2 face="sans-serif">How table entries are we talking about
here? Have you talked to your Basis/Database folks? Have you checked
on OSS? There is a general consolidated OSS note (#706478) on large
tables that mentions table (</font><tt><font size=2>SWWCNTP0</font></tt><font size=2 face="sans-serif">).
</font>
<br>
<br><font size=2 face="sans-serif">If you run the report RSWIWADO how many
workflow runtime tables are showing up in green, yellow or red? (By
the way you might choose to run this report during an off-peak time just
in case it takes a long time!)</font>
<br>
<br><font size=2 face="sans-serif">I hope this helps.</font>
<br>
<br>
<br><font size=2 face="sans-serif">--------------------------------------------------------------------------<br>
Edwin Mukusha<br>
Administrative Systems Group<br>
University of Nebraska<br>
Phone: (402) 472-7756 Fax: (402) 472-7390 <br>
Email: emukusha@nebraska.edu <br>
--------------------------------------------------------------------------<br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Ritapac" <ritapac2004@libero.it></b>
</font>
<br><font size=1 face="sans-serif">Sent by: sap-wug-bounces@mit.edu</font>
<p><font size=1 face="sans-serif">07/06/2006 09:13 AM</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
"SAP Workflow Users' Group" <sap-wug@mit.edu></font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td><font size=1 face="sans-serif">"sap-wug" <sap-wug@mit.edu></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td><font size=1 face="sans-serif">Performance problem on SWWCNTP0 tables</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><tt><font size=2>Hello everybody,<br>
my system is 4.7 (620 - SP lev. 0050).<br>
Each activity on Workitems (log, execution,..) takes long long time, so
the system performance are devastated; the performance trace (ST05) get
a very long time on select in SWWCNTP0 table, but we have done all the
activity to delete completed WI, reorg WF tables, upgrade kernel, and so
on.<br>
It seems that the select on this table is not optimized, but we haven't
found any solution for this problem.<br>
Do you have any idea about that?<br>
<br>
Thanks in advance for your help.<br>
Ritapac<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
SAP-WUG mailing list<br>
SAP-WUG@mit.edu<br>
http://mailman.mit.edu/mailman/listinfo/sap-wug<br>
</font></tt>
<br>