scm0sml
asked on
possible timeout issues when using my ui
Hi,
We currently have a piece of sql that runs that can take a long time, over minutes wouldnt be unusual purely due to the amount of data that is being processed.
I have been asked to put a quick user interface together just so that marketing can kick this job off them selves.
So basically on a button click i will be calling a stored procedure that will run this sql.
What i am worried about is the amount og time it takes to run, will the code timeout etc?
what is the best way to handle this kind of thing? A thread or webservice or?.....
This is the first time I have had to do something that comes up against this issue so dont know what the 'norm' is for handling.
any advice would be appreacited on best practice or at how it would normally be handled.
I would need to some how let the user know that the job has finished via the ui.
We currently have a piece of sql that runs that can take a long time, over minutes wouldnt be unusual purely due to the amount of data that is being processed.
I have been asked to put a quick user interface together just so that marketing can kick this job off them selves.
So basically on a button click i will be calling a stored procedure that will run this sql.
What i am worried about is the amount og time it takes to run, will the code timeout etc?
what is the best way to handle this kind of thing? A thread or webservice or?.....
This is the first time I have had to do something that comes up against this issue so dont know what the 'norm' is for handling.
any advice would be appreacited on best practice or at how it would normally be handled.
I would need to some how let the user know that the job has finished via the ui.
ASKER
It will be a webform.
Will the worker thread be able to report back to the ui to display some notification that it is completed?
Will the worker thread be able to report back to the ui to display some notification that it is completed?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
First of all, will the UI be a winform or a webform? Secondly, regardless of question one, putting it on a separate worker thread will separate it from the UI.
/Carl.