We have realized that application forms require a hugh amount of time for loading the entitlement table if the Business source has a lot of authorizations. We have already filtered for the required entitlement type like this:
The number of available entitlements in this application is quite high:
If we select one user, it will take up to 1 Minute to load the entitlement table for the first time. If we pick the same user a second time it will take up to 20 seconds. If we pick 5 users it takes up to 3 Minutes to load the entitlement table. We have already disabled that IGL should check for outstanding change requests for the user as this will also have a impact on the performance of loading the entitlement table.
Does anyone have any idea how to improve the loading performance for application forms with a high amount of authorizations (with SQL query improvement, extend RAM / disk space of app Server / DB Server) ?