471,605 Members | 1,613 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,605 software developers and data experts.

Asynchronous access to database.

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,

Feb 20 '06 #1
2 1565
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
Feb 20 '06 #2
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

Feb 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by hs | last post: by
6 posts views Thread by Toralf Kirsten | last post: by
reply views Thread by Dave Mullen | last post: by
1 post views Thread by dba123 | last post: by
8 posts views Thread by Simon Gorski | last post: by
reply views Thread by vpidatala | last post: by
reply views Thread by Bishoy George | last post: by
10 posts views Thread by =?Utf-8?B?UiBSZXllcw==?= | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by MichaelMortimer | last post: by
reply views Thread by CCCYYYY | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.