Defect HC-14569
User query very slow with large number of users and organizations
Software
| Customer case | Applies to | Corrected in |
|---|---|---|
| CS0203313 | V9.0.1.0 | 9.0.1.18 |
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.
Resolution
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.