George2 George2 - 3 months ago 40
ASP.NET (C#) Question

SQL Server connection string Asynchronous Processing=true

I am using .Net 2.0 + SQL Server 2005 Enterprise + VSTS 2008 + C# + ADO.Net to develop ASP.Net Web application.

My question is, if I am using

Asynchronous Processing=true
with SQL Server authentication mode (not Windows authentication mode, i.e. using sa account and password in connection string in web.config), I am wondering whether
Asynchronous Processing=true
will impact performance of my web application (or depends on my ADO.Net code implementation pattern/scenario)? And why?

Answer

Just having the Asynchronous Processing=True in your connection string just simply enables you to write asynchronous queries - I don't see how having that setting in your connection string should affect your performance, if you don't change anything else.

You will hopefully begin to see a positive effect on your performance when you start doing asynchronous processing of your database queries. But just specifying that one option shouldn't have any (positive or negative) impact on your app.

Marc