I have a VB dot net allplication which calls a stored procedure.This stored procedure is required to do a lot of computation ,inserts, updates etc for a large amount of data. This is taking a very long time. Is there a way i can intimate the front end as to the amount wrk completed. some sort of a progress bar.
Since the control shifts to the proc i am unable to update the progress bar as the execution proceeds.
thanks in advance
THe second option may be difficult to implement at this stage.
Did not catch the first one though , even if i manage to update a progress table, i will be able to query and send the result back to my front end only when the call to the procedure is over. which may not serve my purpouse.
is there a way with thresds or some thing this can be implemented??
What is the criteria of the progress? Does this procedure works with a cursor and the loops like While ....?
If yes, you can determine a number of loops to be completed and have a counter inside a loop that will update second row of a global temp table of 2 rows that is created inside the stored procedure with a name reflecting a user name for example or containing application-generated unique ID. That may resolve the multipel app instances issue. Then the same instance of the application connects to this temp table and gets the overall number of rows from the first row and a current counter from the second row. This will let it to update the status bar
Do not forget to drop this table at the end of the stored procedure