How the changing of values of session parameters and functional options impacts performance of data access restrictions mechanism
When the system is in operation, it generates a dedicated cache of data access restriction queries in order to improve the performance of data retrieval queries when restrictions are applied. Data access restrictions can use session parameters and functional options. Access restriction queries with defined values of the session parameters and functional options are cached.
However, if the values of the session parameters or functional options used in the data access restrictions change, the accumulated query cache is flushed, which results in significant reduction in data query performance.
This is why we recommend that you define session parameter values "on demand", in the SessionParametersSetting handler of the session module. We also do not recommend frequent changes of session parameter and functional option values during system operation.