-
Title
Performance Optimization: Inefficient Query during Login in the New Web -
Description
During performance analysis of the Web Portal, an inefficient SQL query executed during login was found. It can cause slowdowns on large databases or under high load.
Current Query:
select UID_DialogGroup, GroupName, xmarkedfordeletion from DialogGroup where (uid_dialoggroup in ( select a.uid_dialoggroup from basetree a
join basetreecollection coll on coll.uid_parentorg = a.uid_org
join personinaerole piae on piae.uid_aerole = coll.uid_org and piae.UID_Person = '85b6b3a5-2a6b-473e-8a82-c74a2291e3af')) order by GroupName
ORDER BY GroupNameSuggestion:
Use AERoleCollection instead of BasetreeCollection for a simpler and faster join:
JOIN aerolecollection coll ON coll.uid_parentaerole = a.uid_org -
Cause
An enhancement request (#646128) has been created.
-
Resolution
WORKAROUND
None
STATUS
The product team will evaluate the request and this feature may become available in a future release of the product.
-
Change Request
646128