Sunday, May 13, 2007

What do you mean Asynchronous Database Commands ?

When we execute any database. Thread that executing command waits before command get fully executing before executing any additional code. Thread is blocked for another process. But Asynchronous Database Commands solve this problem when database command is executing current thread can continue on other process.Thread can execute a no of database command. There are two benefits of using Asynchronous Database Commands.
A.Executing Multiple Databse Commands simultaneously improve performance.
B. Because ASP dot Net framework uses a limited pool service for request. Whenany request for a page is comes its assign a thread to handle the request. If framework is out of thread then job is in gueses we get error 503. But if we are using asynchronous database command then current thread is release back to current thread pool."

No comments:

 
Dotster Domain Registration Special Offer