We have Saviynt user form for new user request. This is built basically on lots of dynamic attributes created with SQL quires pulling data from tables. This has drastically slowed down the user form loading. Can someone please let me know is there a defined way to speed up the loading of the page still with all the dynamic attributes in place?
This is urgent. Please help me asap.
You need to make sure the sql queries run on DA should be optimised queries, Also try not to fetch all data and try to minimize the data with filters so that the query runs faster.
Also make sure the parent child relationships, Mapping is correctly configured so that there is no unnecessary data being loaded.