Background task to execute a database query

Hello,

I have a html page where user can click on various links and each link displays some information in a small popup window. On click of each link I am running a database query which takes about 70 sec to return the results.

Since the query is taking a while to execute, User will not see the information instantly. I want to execute this query as a background task. If the user clicks on any other link when there is already a query executing then I need to cancel the exiting query process and execute a new.

I am not sure how to accomplish this task i.e running a background process and cancelling the existing one if a new request is initiated in the meantime when already another process is running.

Can any body please help. Also suggest if there is any other way to get this done.

Thanks in advance for any help,

	Author	Topic: Background task to execute a database query (Read 894 times)
0 Members and 1 Guest are viewing this topic.