Hi Community,

I am tried using EE 4.8 for evaluation and built flash charts representations of a large data set (around millions) in my dashboard. I managed to successfully create and save them. The problem arises when I open or load the dashboards. It seems that it takes quite a while (around 5 minutes or more) for the chart to show. I am not sure if this is caused by network latency since the database/data mart is located on a different server in the network. What is the best practice in implementing a data mart in Pentaho. Should the server and database be located on a single machine/server? or can the data mart be located from a different machine other than the Pentaho server?

Thanks and regards.