How to configure Knowage for high performance?

Question

Hi friends, In relation to my question, I have a problem with the execution time of a report which is composed of a Data Source of a MySql Database.
The table has 615000 records. In the MySql Workbench the grouping queries are obtained in less than 4 seconds and in turn they are created in table Views. But in the Knowage Designer and the Server, the report shows it in more than 25 sec.
How should I configure the Cache or how can I improve the presentation of the reports or Cookpit in a few seconds (5s) ?

The Parameter of JAVA -Xmx I have it configured in 6144m
I have 8GB RAM

I configured in the Report the seconds for Refresh for 30 days but it still takes too long to show the report and that I am only doing all the tests in a Local PC.

I hope you can help me.

regards
Juan

Comments

Is MySQL running on localhost as well as Knowage?

---

Yes, friend.

Answer 1

Hi,

It depends on how you use it.

First, as you said, there are 615,000 records. Do you need to show each detail in the report?Otherwise, you should aggregate, or better yet, use big data tools to do offline preprocessing, and the final report will show only aggregated data, which will be much smaller.

Second, because Knowage used anglajs for page rendering, you should reduce the number of widgets in a single document because the more widgets you have, the slower the page renders.In addition, you can use the BIRT engine for developing reports, probably faster than Cockpit.

I hope it helps.