Version 9.1.206 (19 January 2026)
People Management
Change people groups query to use dynamic parameters to avoid parameter sniffing (#143512)
Problem
- The dapper query to fetch the list of people group users can, at times, take extremely long.
- This is due to the query plan caching and the parameter sniffing that is required with the current implementation.
Solution
- Added OPTION RECOMPILE to the temp table insert query, additionally changed the Dapper parameters to be dynamic to allow specifying the exact types, which enables SQL to create a better execution plan.
- Date values are submitted through as datetime parameters and not as varchar
System Access
Resolved system access not saving, throwing a sorry page (#143531)
Problem
- Url changes implemented for validation, and a new object is stored as JSON. Within the JSON conversion, it could not deserialise correctly
Solution
- Add implementation to navigate and correctly add items to a new list