QV Running Slow

[#1]

Hi QV folks,

I developed a simple dashboard. The data structure is simple, an inpatient table and an emergency department table linked through a link table by account.

I created several charts for both inpatients and emergency department tabs/sheets; however, my emergency department sheet runs extremely slow. One of the issue that I found through google is that I used count(distinct) function because the emergency table has duplicate account to account for cycle time of each individual process step. I modified my data table to be able to use sum(). But QV still runs slowly.

I have developed 2 dashboards using QV before and have never seen such a issue. Does anyone have similar experience and would like to share your resolutions? Andif you have any references materials to optimize QV performance?

Thank you so much!

Regards,

Jihan

[Clever_Anjos]

Some tips:

1) Check if you have Synthetic Keys, they could (not always) make your performance poor.

2) At Sheet Properties / Objects tab check which object is the slowest

3) Try to isolate each expression of that object

[#3]

Thank you for the reply.