Asynchronicity or not.....

[scotttom]

I need some guidance..... I need to run a stored procedure but I don't want to wait for the results.

This SP can take up to 4 minutes to run and I don't want the users to have to wait before moving on in the code.

I found an article with a model that I followed, but it does not work and I don't know how to troubleshoot it.

http://www.databasejournal.com/features/mssql/article.php/10894_3427581_2

Am I even on the right track with this?

I've also seen scheduling a job as a potential solution, but the inserts are somewhat infrequent, so that seems like the wrong approach to me.

Thanks in advance for any help.

Scott

 

[SQLSister]

why not performance tune the sp? Very few sps that do something for the user should take 4 minutes.

"NOTHING is more important in a database than integrity." ESquared

 

[scotttom]

WOW! What a great idea! ;-)

This is what I am doing and it takes a long time....

http://tek-tips.com/viewthread.cfm?qid=1369136&page=1

Thanks for your reply though.

Best,

Scott

 

[Jamfool]

Hi,

You can easily handle this using an asynchronous call from the application level. Assuming that you are writing this in dot net the following article is quite useful.

http://www.codeproject.com/csharp/AsyncMethodInvocation.asp

 

[ca8msm]

Why does the SP need to be asynchronous? Shouldn't wherever they are running it from be the one that performs the action asynchronously (I assume the users are running this from some sort of application rather than directly from a sql client tool)?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[scotttom]

Welllll..... so it's an Access front end, so no Asynchronicity is possible.

We do most of the heavy lifting on the SQL server, and the front end is so big we can't invest in an upgrade now...... you know the story.

So am I on the right track?

Thanks for the replies,

Scott