"And whoever is removed away from the Fire and admitted to Paradise, he indeed is successful." (The Holy Quran)
Excellent Windows VPS Hosting Imran Baloch MVP, MVB, MCP, MCTS, MCPD
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.
LearningASP_...
Member
242 Points
256 Posts
Async Database Request. How do you check
Jun 10, 2011 06:50 AM|LINK
Hi
Can anyone tell me how i can check that my Async database request is actually async. I'm using HomeController : AsyncController
Thanks
George
imran_ku07
All-Star
45864 Points
7713 Posts
MVP
Re: Async Database Request. How do you check
Jun 11, 2011 05:17 PM|LINK
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
Excellent Windows VPS Hosting
Imran Baloch MVP, MVB, MCP, MCTS, MCPD
LearningASP_...
Member
242 Points
256 Posts
Re: Async Database Request. How do you check
Jun 11, 2011 06:11 PM|LINK
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
bruce (sqlwo...
All-Star
37616 Points
5574 Posts
Re: Async Database Request. How do you check
Jun 11, 2011 10:56 PM|LINK
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.