Slow Loading User Create Page

[sab2]

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

[sahil]

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.

[nimitdave]

In addition to @sahil 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]

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?

[sahil]

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

[sab2]

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