I have a CDE dashboard developed with Pentaho CE 6.0.1 with 4 line charts. My plugins are updated.
Our dataset is a SQL Server database with millions of records (near to 80 millions).
The BA Server is running in a cloud enviroment as the database as well and queries in database motor run at very few seconds.
The dashboard performance is very poor, it takes almost 2 minutes to full load. I tried to remove 3 of the charts and leave only the principal but the load times didn't change at all.
Do you think I need a big data approach for this amount of data?
Can you please help me providing me some performance tuning tips in order to improve this behavior? Any help is appreciated!