I have built a dashboard to monitor our jobs which run from 8 PM to 8 AM.
The dashboard just takes 10-15 Seconds to refresh from server, and I have an EDX procedure to refresh this dashboard at will from Web Browser.
I intend to schedule this dashboard from 8 PM to 8 AM to refresh every 5 Min to get a (near to) real time data.
This is a production server so I have the questions:
- Is QlikView capable of handling real time refresh every 5 Min?
- Will there be any server level impact?
- Are there any best practicies with this regard?