Calculated Measures is simple,but there are many columns in the table chart, can I modify the advanced setting to improve the load performance? if yes, let me know which settings I can made and how to set them, thanks
by the way, below settings have been made, but the improvement is less.
1、database advanced settings: pool=60
2、child process>> jvm options -Xmx90g
Best Regards
Annie Gao
Hi @xinranmo
Many columns in the report may slow down due to the sheer amount of data eazyBI has to generate from the table view. This kind of report is also hard to read for users.
I recommend redesigning the report layout to reduce the column count and using some of the information as page filters to run the report for smaller, more focused portions of data. Or make it more of an overview report, leaving users an option to interact with the repot and drill through issues behind the aggregated numbers (Interact with report)
If the report is not meant to be interpreted by users but you want to process data further in some other tool, like Excel, consider an alternative option to export the report results with REST API (see the documentation for more details: Report results export API).
Best,
Zane / support@eazyBI.com