Skip to Content
0
Apr 16, 2014 at 09:43 AM

Performance issue while accessing SWwLOGHIST & SWWHEAD tables

1448 Views

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