Long loading times are experienced in the Angular web portal Specific endpoint portal/resp/team/responsibilities?forinactive=1 (4382994)

Long loading times are experienced in the Angular web portal Specific endpoint portal/resp/team/responsibilities?forinactive=1

The out-of-the-box query to load the web portal contains a query that can have very long delays in some customer environments.

If this occurs it can be determined by analyzing the page load time in the developer tools of the web browser.

If the end-point causing the delay is portal/resp/team/responsibilities?forinactive=1. you can check this by observing the query once trace logging is enabled and look for the  the SQL query in the API Server log.

 

In the below log excerpt, the query took over 46s (most queries take under 10 ms)

DEBUG (    SqlLog itivqcgzxowsur9ck3z3rumw) : (46826 ms) - select count(*) from QERVPersonAndAERoles where (uid_person in (select uid_person from QER_VEditEmployee where uid_personhead = 'f1923b80-b058-4a5b-8c23-0c8ef08bbe1d') or uid_person in (select uid_person from personinorg where uid_org in (select uid_org from org where xobjectkey in (select objectkeyassigntarget from qerassign where uid_accproduct in ( select acc.uid_accproduct from accproduct acc join personinbasetree piae on piae.uid_person = 'f1923b80-b058-4a5b-8c23-0c8ef08b541d' and piae.uid_org = acc.uid_orgruler))))) and (UID_Person in (select p.uid_person from person p where p.Isinactive = 1 union all select p.uid_person from person p where (p.Isinactive = 0) and (p.ExitDate < '2000-00-00 01:01:47.522'))) and ((UID_Person in (select hpo.UID_Person from dbo.QER_FTHelperHeadOrgChildren ('f1923b80-b058-4a5b-8c23-0c8ef08bbe1d') c join HelperPersonOrg hpo on hpo.UID_Org = c.UID_Org union select hho.UID_Person from HelperHeadPerson hho where hho.UID_PersonHead = 'f1923b80-b058-4g6b-8c23-0c8ef08bbe1d' and XOrigin > 0)) or (exists (select top 1 1 from QER_FTPersonsAreMe_S ('f1923r90-b058-4a5b-8c23-0c8en38bbe1d') f where f.UID_Person = QERVPersonAndAERoles.UID_Person)))