Distribution of value taking more time to load | Community
Skip to main content
G
Greeshma_Sampath1
Level 4
July 1, 2021
Question

Distribution of value taking more time to load

  • July 1, 2021
  • 1 reply
  • 1450 views

Hi All,

 

The Distribution of Values button used for fields with a defined LOV while building a Query activity has regularly taking more than a couple minutes to load the LOV or (more often) gets stuck in a hung state (loading list). If the user doesn't click Cancel then this results in an error.

The Targeting dimension and Filtering dimension are different schemas. Is it because of that, this loading time is more? The issue is coming in Production environment and the Distribution of Values is loading within 20 seconds in Stage environment.

 

Could someone please help us figure out the issue and resolve it.

 

Thanks.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
July 2, 2021

Hello @greeshma_sampath1 

 

It seems to be a indexing issue. Can you check if the field you are trying to pull is indexed?

 

If it is then it should not take much time. May in staging you have less data that is why it is loading under 20 seconds.

Manoj  | https://themartech.pro
G
Greeshma_Sampath1Author
Level 4
July 6, 2021

Hi _Manoj_Kumar ,

 

The field is indexed and the number of data is same for stage and prod.

Is there any other probability that might have caused this issue ?

 

Thanks

Terms & ConditionsAccessibility statement

Loading footer...