Continue to use the Laravel application during query execution

Question

I have a query that updates all rows of a table in a MySQL database.

This can take up to several hours, and while the request is running, my application remains in a download state.

How to continue using my application while query is running? That is, run heavy queries in the background.

Answer 1

Have you tried using queues? They are built for this purpose.

https://laravel.com/docs/5.5/queues