Thanks for your feedback and suggestion!
Our users would like to use QV to display 1 month to 1 year of data (2 Billion rows of data) using the QV drill-down method. Originally, we thought that the QV display time is linear with the volume of data to be displayed using the drill-down method:
-- 1-2 sec to display 1 month of data
-- 6-12 sec to display 6 months of data
-- 12-24 sec to display 1 year of data
Instead, the QV display time is:
-- 15-20 sec to display 1 month of data
-- 15-20 sec to display 6 months of data
-- 15-20 sec to display 1 year of data
It appears that QV always queries the full data set (2 billion rows of data) whether we display 1 month, 6 months, or 12 months of data
What can we do to speed up the QV display time when we only display 1 month of data?
Regards.. Khai Le
HI Khai Le, For improving the performance, 1) Remove Unwanted fields 2) In expression, use set analysis 3) Avoid IF condition in expression 4) Avoid count function 5) Avoid calculated dimension 6) Use variable in the expression (Example : sum(sales); Instead of sum(sales) in expression, Variable1 = sum(sales) and pass Variable1 in expression 7) remove synthetic keys and circular loop in the QVW Hope this will helpful for you. Regards Sathish