on 04-16-2014 10:43 AM
Hi,
We have applied workflow function in Purchase Order (PO) for release strategry purpose. We have two release levels.
The performance issue came while user who tried to update the existing PO in which the PO had already released. because after user amend the PO and then they pressed "SAVE" button in PO's screen, the release strategry will reset and it tried to read the SWwLOGHIST table, it took few seconds to minutes to complete the save process.
My workflow's schedule job details as below:
SWWERRE - every 20 minutes
SWWCOND - every 30 minutes
SWWDHEX - every 3minutes
Table Entries:
SWWHEAD - 6mil entries
SWwLOGHIST - 25mil entries
Should we do data archiving on the above workflow tables?
Is it only the solution?
Kindly advice,
Thanks,
Regards,
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check whether the statistics of these tables are updated.
Perform an SQL tracing using the Tx ST05 and check the execution plan.
Archiving or deleting the date will not improve the performance. If there is mass deletion of data then I would consider doing a reorg of the tables and rebuild the indexes.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
Archiving should be a good solution with such large number of entries.
Check out the following
Refer point 4 of SAP note 706478 - Preventing Basis tables from increasing considerably
Refer SAP note 49545 - Deleting unnecessary work items
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak,
So far, we have yet to setup any storage server/dvd to intergrate with ECC for archiving function.
It is possible to proceed with write & delete steps in WORKITEM archive object although that is no storage been stored? In other words, which is delete the work flow data parmanently?
Not too sure whether auditor will need to check those workflow logs or not.
Any idea?
Thanks,
Regards,
Thomas
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.