I have created a view and put it on a custom page using panels.
Sadly my query is too complicated and the page times out after about 10 seconds. On top of this i wanted my page to provide a 'loading' indicator to provide some feedback.
Now i am aware of batch api as being the most reasonable solution, at what stage can i get my view query to execute a batch run? I have thought about hook_views_pre_execute() but i think this is too late.
Has anyone any idea how to process a page load with batch api, or an alternative solution?