时间戳

首页 > 解决方案 > Pentaho Dashboard Performance

bigdata - Pentaho Dashboard Performance

问题描述

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?

Thanks a lot for any help!

标签： bigdatapentahodashboardpentaho-cde

解决方案

使用 sql server 你会遇到这个问题，解决方法是你可以增加 ram ，你可以启用 catch 所以第一次它需要一些时间，之后它会很顺利，但又没有具体的解决方案。您必须更改为 HP vertica 等列式数据库，或者您可以在架构级别进行更改，创建数据仓库并仅存储必要的数据

推荐阅读