Asynchronous access to database.

  • Thread starter Thread starter archana
  • Start date Start date
A

archana

Hi all,

I am having application which is executing one stored procedure.
My stored procedure is taking nearly 10 to 15 min to execute. So i
dont' want to wait for that much amount of time.

What i want is to create say 2 threads and execute same stored
procedure with 2 different paramter with two different thread.

In short i want to execute stored procedure asychronosusly. I am having
studio 2003 and not 2005.

I know in .net studio 2005 there are methods provided for asychronous
execution.

But i want to implement it in 2003.

Can someone tel me how to do this.

Any help will be truely appreciated.

Thanks in advance,
 
archana said:
I am having application which is executing one stored procedure.
My stored procedure is taking nearly 10 to 15 min to execute. So i
dont' want to wait for that much amount of time.

What i want is to create say 2 threads and execute same stored
procedure with 2 different paramter with two different thread.

In short i want to execute stored procedure asychronosusly. I am having
studio 2003 and not 2005.

I know in .net studio 2005 there are methods provided for asychronous
execution.

But i want to implement it in 2003.

Can someone tel me how to do this.

Any help will be truely appreciated.
Click to expand...

Just start a new thread and within that thread work synchronously.
 
Jon, what's the pros/cons of using async call with delegate-driven approach,
performing BeginInvoke, in that case?

PS: let's put aside desing issues

archana said:
Hi all,
I am having application which is executing one stored procedure.
My stored procedure is taking nearly 10 to 15 min to execute. So i
dont' want to wait for that much amount of time.

What i want is to create say 2 threads and execute same stored
procedure with 2 different paramter with two different thread.

In short i want to execute stored procedure asychronosusly. I am having
studio 2003 and not 2005.

I know in .net studio 2005 there are methods provided for asychronous
execution.

But i want to implement it in 2003.

Can someone tel me how to do this.

Any help will be truely appreciated.

Thanks in advance,
Click to expand...

--
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
 
Back
Top