Report/dashboard slow in updating - what determines this?
I'm building a report by joining, union sub-query, 14 views. The report has become very slow in updating ~10 minutes or more. What determines performance?
I've tried using Chrome and Firefox without any difference.
The combined report consists of ~55000 rows which I would assume is not a large amount of data.
The resulting report consists of 13 columns.
Since I'm displaying charts I assume the Active Row Limit must be set to ~55000 rows?
As the purpose is to provide a list of data is it best only to work with the table, skip the charts, and have the Active Row Limit set low, 10000?
I've noticed that the views have a number of fields not contributing to the data. Does this matter?
Is the union sub-query requiring lots of resources causing the performance to suffer?
Any suggestions welcome.