Pre-populating data sets with data from long-running queries requires special programming efforts and while it might solve the problem without risking infrastructure stability, this approach is often less practical.
Arnica WebReport provides an out-of-the box solution for serving data from long-running queries. The solution is based on using Arnica NanoQuery as a data source and specifying a wait timeout, which controls how quickly a browser sends a response to the user that the process started at the backend.
User may click on RELOAD button which checks if the query completed.
If the query is still running, user will still get the same response, but when results are ready the next RELOAD will show results:
With this approach users will not get timeout messages, and no infrastructure adjustment results will eventually be displayed.