How in Yii2 to ensure the current work in adjacent tabs, if the user launched a "heavy" (long) query?

Question

Yii

Yii2. The user runs a report that takes several minutes to generate. While the report is being generated in adjacent tabs, it is impossible to work until the report has been processed. In another browser or in "incognito" everything works in parallel.
The problem is not the load on the server.

Answer 1

Maybe it makes sense to put this operation in the background? through queues + notification "report generated, can be downloaded" after, than to keep a long connection? This will definitely remove the problem
. And did you look at the browser profiler, what about the resource consumption of the tab with the report?

Answer 2

If sessions are stored in files, then close the session before starting a heavy request, since PHP cannot open a new session if the previous one is not closed