Any harm in using Async=true to sql server 2005 for non-async db calls

C

Chris Becker

Is there any harm (performance or otherwise) in using "Asynchronous
Processing=True" in my connection string to a sql server 2005 database
for both async db calls and non async calls? The idea behind it is
taking advantage of connection pooling, and everything seems to work
fine using the Async connection string for all calls, but I don't know
where to look for more information on this.

Thanks
 
W

William \(Bill\) Vaughn

That might (just might) cause some additional code paths to be entered that
would not ordinarily be called... I've never done any performance metrics on
it. I would not be surprised if it did.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connect without async but get timeout error when async=true 5
Server-side Asynchronous Calls in Web App - Of what Value? 2
Asynchronous calls to sql server 2000 3
Parrallel Page Async Tasks not running in parrallel 7
Async Calls to DB does not help in the efficiency department? 3
C# Async Socket timeouts 6
Blocking calls in AsyncCallback? 3
Exceptions from SQL Server 2005 1

Top