Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Slow Loading User Create Page

sab2
Regular Contributor
Regular Contributor

Hi,

We are using the user create forms for onboarding and we are noticing that the form is loading pretty slowly. Does anyone have suggestions on how to speed this up? or experienced something similar with the user create form? We have roughly 19 dynamic attributes and utilizing the action strings, validation queries and reference a dataset. I put some queries below. Any tips would be appreciated.

  1. select distinct (concat(lastname, ' ',firstname, ' - ',username)) as ID from users
  2. select attribute1 as ID from dataset_values where datasetname='12222'
  3. select distinct companyname as ID from users
  4. Select id from(select case when FIND_IN_SET("Employee",${u})!=0 then 'abc123' end as id union select case when FIND_IN_SET("Employee",${u})!=0 then 'xyz432' end as id) where id is not null
5 REPLIES 5

SB
Saviynt Employee
Saviynt Employee

The dynamic attributes that you use for the request form can certainly cause the slowness if the queries are not well optimized. The 1st & 3rd query looks fine but the last query could be causing some slowness unless you are using a query in any other attribute as well.

Also for query2, do you have dataset_values table in your instance?

1 way to check is, to remove the last query from the attribute and see if the performance changes. You can do similar check to validate any complex queries you might be using.


Regards,
Sahil

nimitdave
Saviynt Employee
Saviynt Employee

In addition to @SB comments , following points can be checked:

1. Check how many attributes are using Mapping and Parent Attribute. Make sure only required attributes are having these values set as these settings will make the whole form reload and revalaute for each attribute.

2. Use queries with proper filters like if you are displaying supervisors/managers list then add department or some other properties in the where clause.

3. Design the form in such a way that the previous attribute can be used to narrow down results in the current attribute.

4. Add null checks in the query.

sab2
Regular Contributor
Regular Contributor

thank you for these recommendations. we have tried updating mappings and different queries, however the page is still loading very slowly.

based on #4, 'add null checks in the query' what do you mean by this?

SB
Saviynt Employee
Saviynt Employee

Can you confirm if this is still an issue or was this resolved.


Regards,
Sahil

sab2
Regular Contributor
Regular Contributor

We are still working on the form speed / query improvements. It is taking roughly 30 seconds for our create form to load.