CakePHP, MySQL query taking time which locks my UI

I have a peculiar problem which has arisen in my application off late . In one of the pages , a sql query is taking too much time to load , and it is causing my UI to get locked . What开发者_开发知识库 happens is untill and unless that query gets completed in the backend, I can't see anything in the browser .

Also , if I open a new tab and hit the same url there, my browser won't show anything and will wait till my query finishes.

In the present scenario, I can't change the query immidiately , it needs time to optimize it, but till then I need some time-out settings wither in the mysql db or in cakephp, where in my UI won't wait for the query to finish.

How to do that?

don't execute the query on page request. Put an ajax call in your page and call another action that execute the query and return the result.