Performance Issue displaying Summary Dashboard

Hi ,

We are facing slowness while displaying Summary dashboard for a record(Say Employee is a Record Type and we are accessing Employee1), whose "Other" view is querying 10,000 records .

While if we try to access some other record(say Employee2) whose "Other" view is querying 100 records we are not facing slowness/ not taking much time to load.

In Summary dashboard Interface we are not query table that contains 10,000 records, but still we are facing slowness. 

We are querying data from table that contains 10,000 records in "Other" view Interface.

 

Please suggest, What can be the reason for slowness and how can it perform better.

 

Thanks

Namrata

  Discussion posts and replies are publicly visible

Parents
  • Hi Namratak,

    How are displaying the 10,000 records data that you are querying? Is it in Paging Grid?,
    If yes please check How the coding is done are you getting all the 10,000 records in Load variable? Please try to hit the rows that are required for first time loading.
    Are you using Query Rule or Query Entity?
    Please check the Query Entity to pull only required columns in batches say 15 or 25 that depends on your requirement.
    Also you can have indexes on the View that you are using.
Reply
  • Hi Namratak,

    How are displaying the 10,000 records data that you are querying? Is it in Paging Grid?,
    If yes please check How the coding is done are you getting all the 10,000 records in Load variable? Please try to hit the rows that are required for first time loading.
    Are you using Query Rule or Query Entity?
    Please check the Query Entity to pull only required columns in batches say 15 or 25 that depends on your requirement.
    Also you can have indexes on the View that you are using.
Children