Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The requirement of our dashboard is to show the data in detail and summary tabs.
The count of data per day is approx. 5 Millions and in the dashboard we are showing the 15 days data.
So , the problem is , we are pulling in all the 5 Millions * 15 Days data in the details tab , due to which the performance of the dashboard is degrading and there is always a lag when we select any filters or move across the tabs.
Can you please provide some solution to tackle this problem ? As how we can optimize the performance.
Thanks
Save the data out to QVD(s) as a first step.
Hi,
How many fields you have?
are you use complex calculation?
Is your machine hosted on VM?, If yes you need physical machine.
How much ram and CPU you have?
Regards
ASHFAQ
Hi,
If you can't aggregate the data you should add calculation condicionals like selecting one day or something that filter your data in order to limit the number of rows. you can also add buttons also with tipical user filters.
I don't think the users need all the data at the same time.
Cheers,
David
I would also consider building a more aggreagted Dashboard file for fast performance and then have a separate Dashboard with the detailed data. Use document chaining when the user needs to move from aggregated to detailed data.
Michael.
QVD is already setup.Thanks
There is no complex calculation involved , its the Raw data which is being dumped into the dashboard.
The data is filtered based on the dates. But the problem is each business day as 5 Million volume data.
Can you please guide me in implementing the Document Chaining?
on opening the dashboard, restrict the data to latest 3-5 days, if the the user wants to see all 15 days data then he will use the clear option.