Async Database Request. How do you check

Can anyone tell me how i can check that my Async database request is actually async. I'm using HomeController : AsyncController

Thanks

George

Re: Async Database Request. How do you check

Thes are helpful links,

http://blogs.msdn.com/b/rickandy/archive/2009/11/14/should-my-database-calls-be-asynchronous.aspx

http://weblogs.asp.net/imranbaloch/archive/2011/05/10/asynccontroller-v-s-sessionless-controller.aspx

Re: Async Database Request. How do you check

Hi imran_kuo7

If possible could you check the following link and let me know whether this is the correct way to do async request to database

http://forums.asp.net/t/1688910.aspx/1?AsyncManager+OutstandingOperations

Regards

George

Re: Async Database Request. How do you check

it depends on the database api. if your api has async support, with async callback then its probably async. but with sqlserver, even if you use the async api, some operations (depends on the server query plan) are sync and the thread is not released (the completion routine is called before the start async method returns).

you can tell with logging. have the completion log when it runs, and log right after the start async method. if the completion runs first, then you are not getting async.