Distribution of value taking more time to load

Avatar

Avatar
Give Back
Level 1
Greeshma_Sampath1
Level 1

Likes

0 likes

Total Posts

43 posts

Correct reply

0 solutions
Top badges earned
Give Back
View profile

Avatar
Give Back
Level 1
Greeshma_Sampath1
Level 1

Likes

0 likes

Total Posts

43 posts

Correct reply

0 solutions
Top badges earned
Give Back
View profile
Greeshma_Sampath1
Level 1

01-07-2021

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.

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

115 likes

Total Posts

328 posts

Correct reply

101 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile

Avatar
Affirm 100
MVP
_Manoj_Kumar
MVP

Likes

115 likes

Total Posts

328 posts

Correct reply

101 solutions
Top badges earned
Affirm 100
Validate 1
Contributor
Ignite 1
Shape 1
View profile
_Manoj_Kumar
MVP

02-07-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.