hrhap_document_get_detail slower after EHP3

[Former Member]

Hi Guys,

We installed Enhancement Pack 3 recently and we noticed a performance loss for a function hrhap_document_get_detail, retrieving informations on appraisals. This function is a standard function, used in a z function to loop on an appraisal table to retrieve the details of these appraisals. After EHP3 was installed it takes twice as much time to get theses details.

Any idea why and what could be done to improve the performances?

Thanks for your help in advance.

[Former Member · Accepted solution]

There are no errors or warnings but we recieve a huge delay in retrievng the data. This did not occur before the enhancement pack 3. Please advice if you know how we can increase this performance:

Thank you in advance

[Former Member · Accepted solution]

You can check what is taking more time by ST03N, STAD and finally you can think of ST05 (Performance trace)

[Former Member]

Can you please check the over all system performance. make sure you observe the tables with respect to hrhap_document_get_detail.this contains many cluster tables and HR infotypes.

you can post sM21/St22 and posts on this. can also check table&tablespace growht.

regards

nag