ESS team calender performance terrible

[former_member186143]

when a user want to see it's teamcalender the average time of retrieval is between 60 and 90 seconds.

I don't know if we made a customizing error or that something else is wrong. I debugged the problem from

PT_ARQ_TEAMCALE_GET until the function HR_BLP_GET_DEPENDENT_RECORDS

which causes 90% of the delay.. if it was only database delay for retrieving the data I could understand but 95% is abap runtime. there was also a note mentioned in this function 490611 which should have already upgraded the performance but clearly it doesn't and it goes through the optimized coding.

is there a way to skip this function i.e. do we have a choice in customizing ?

I found it hard to believe that the rest of the world would be happy with this performance since I haven't found any calls on this problem ?

kind regards

arthur

[former_member186143]

putting indexes on the table would only help if I would found that most of the time would be consumed by retrieving the data.

we did some tests with the current setting and 2 months and put it back to 2 months.

[siddharthrajora]

Apply these notes 1364914

1353199

1330997

and follow customisation as per note 1294238, Where it advises to have two months data to be displayed in calendar

This will improve the performance

[igor_vernelen3]

Hello Arthur,

We faced similar problems and as is suggested by Siddharth Rajora the only thing you can do (since it is a standard SAP Application) is to lower the number of months to be displayed in your calendar by customizing.

Maybe it can also help to update your indexes/database statistics for the frequently read time-tables in the teamcalendar, e.g. PA2001, PA2002, PA2006,...

Kind Regards,

Igor.

[MarkusKlein]

>

> when a user want to see it's teamcalender the average time of retrieval is between 60 and 90 seconds.
> 
> I don't know if we made a customizing error or that something else is wrong. I debugged the problem from
> 
> PT_ARQ_TEAMCALE_GET until the function HR_BLP_GET_DEPENDENT_RECORDS 
> which causes 90% of the delay.. if it was only database delay for retrieving the data I could understand but 95% is abap runtime. there was also a note mentioned in this function 490611 which should have already upgraded the performance but clearly it doesn't and it goes through the optimized coding.
> 
> is there a way to skip this function i.e. do we have a choice in customizing ?
> 
> I found it hard to believe that the rest of the world would be happy with this performance since I haven't found any calls on this problem ?
> 
> kind regards
> arthur

Hello Arthur,

what settings do you have in table view V_PTARQ_TCONSTR for "Display Previous Leave in Team Calendar Up To:"?

Please also check SAP Note 1364914

regards,

Markus