Loading data in lookup table is very slow for some users.

[poojitha bn]

Hi,

We have opened_for and subject_person reference fields in sn_hr_core_case table.

Look up table is taking long time to load data in select box.(Dev environment its working fine but problem is in test and prod )

compared Business rules , ACL'S and client scripts but its same in both environment.

I wanted to know what else will impact loading look up table 

This issue is very random and happening for only few users from different countries.

[SaiRaviKiran Ak]

Below link could help you out:

https://community.servicenow.com/community?id=community_question&sys_id=53fb0725db9cdbc01dcaf3231f96...

[poojitha bn]

Hi Sai,

Thanks for the response but our case is little different.

Thanks,

Poojitha BN

[poojitha bn · Accepted solution]

Our production instance having lot f empty HR profile. when I click on Look up table which is pointing to hr profile table was taking time to load data.

We have deleted all empty and cleaned up HR Profiles now its working great as expected.