Skip to Content
2
Former Member
Jun 27, 2013 at 10:38 AM

Leave request approval - insert on PTREQ_HEADER is very slow

808 Views

Hi experts,

We are experiencing a major issue on the performance of leave request approval. The approval step is taking more than 1 minute per request!

We already did a trace on production system (see attachment) to find out the reason for this awful performance and we found out that an SQL statement to insert a new entry on table PTREQ_HEADER is taking 67 seconds.

We analyzed this table in detail and it has more than 1,3 million entries. Please find enclosed all details about this trace.

Do you recommend to delete old requests already approved using the standard programs RPTARQDBDEL etc?

We are about to upgrade to EHP5 using the new WD for requesting and the new inbox WD application (ibo_wda_inbox) available with MSS Addon 1.0,

but I guess the performance will not get any better as it will use the same coding. Is that so?

Thanks in advance.

Cheers,

AS

Attachments