Asynchronous access to database.

[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,

[Jon Skeet [C# MVP]]

archana <tr**************@yahoo.com> wrote:

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.

Just start a new thread and within that thread work synchronously.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Michael Nemtsev]

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" wrote:

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,

--
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