Hello,
we are experiencing some performance problems with BI Publisher reports.
Since I am not so familiar with BI Publisher, I wonder if this is a matter of correct BI Publisher settings.
This is the behaviour that we noticed after some analyzing of the runtimes:
- we have a dashboard page with 5 BI Publisher reports - one is separate (always displayed), 4 are under 4 different (BI Publisher) tabs
- when we open the dashboard page, all five of BIP reports are loaded (even those on the inactive/not displayed tabs), SEQUENTIALLY - this takes about a minute!
- once the BIP reports are loaded, we are on an active tab - if we switch now to one of the inactive tabs, ALL 5 BIP reports get loaded again! But since the data was now cached, the actual sql/query part takes 0 seconds, but each BIP still takes a few seconds to build/render from that data. So it takes a while to even switch the tabs.
- if we go back to a tab that we already had opened, the switch is almost instant
Here are my questions, if it is possible to change that via settings or fix somehow else:
- Is it possible for BIP reports to load all at the same time, just like a standard dashboard page with multiple analysis reports would?
- Is it possible to change that not all reports get loaded, but rather just those that are currently displayed on the screen? Which would mean that those in non-displayed tabs would not get loaded.
- Why do all 5 reports get loaded again when I change tabs?
- A bit of a separate question, do temp files that begin with xdo and end with .tmp belong to BI Publisher? I am noticing on our filesystem we have a lot of old temp files (some are several months old) like that, that are quite large...
Example:
xdoP4N6XGKAtH1710921179631585974.tmp
xdoyn26GlIt9R5154223478261218658.tmp
Would it be safe to delete these?
Thanks for the help