PC Review


Reply
Thread Tools Rate Thread

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

 
 
Chris Becker
Guest
Posts: n/a
 
      23rd Mar 2007
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

 
Reply With Quote
 
 
 
 
William \(Bill\) Vaughn
Guest
Posts: n/a
 
      23rd Mar 2007
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)
-----------------------------------------------------------------------------------------------------------------------

"Chris Becker" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect without async but get timeout error when async=true Joseph Microsoft ADO .NET 5 16th Jul 2008 10:13 PM
writing an async client (sockets/async/thread) asharda@woh.rr.com Microsoft C# .NET 8 17th Mar 2008 10:04 PM
Csharp async calls to Web Service that calls C++ :: blocking issue Brian Parker Microsoft C# .NET 10 21st Apr 2006 03:12 AM
async calls =?Utf-8?B?Tm9ybUQ=?= Microsoft Dot NET Framework 7 5th May 2005 01:53 AM
Re: Async calls Ilya Tumanov [MS] Microsoft Dot NET Compact Framework 0 8th Jul 2003 11:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:50 PM.