Defect HC-14570

User query very slow with large number of users and organizations


Customer case Applies to Corrected in
CS0203313 V9.0.1.0

Observed behavior

When checking for CSR role, the query takes up to 10x longer when the role is at the store level instead of at the extended site level.

Expected behavior

There should not be an appreciable difference in the performance of the query for CSR roles at different levels in the hierarchy.


The query used to fetch the role data from the database has been improved to make it approximately the same time, regardless of level in the hierarchy.