Multiple ConnectionStrings & Performance

I have read that connection pooling helps database performance and that making seperate connection strings for reading/writing helps.  The connection pooling part is obvious, but I am not sure about the multiple connection strings based on their role.  Is this true?  Is it better to have a connection string for reading and one for writing, another for updating - or would one connection string for my whole web app be sufficient?

Does this matter, or am I looking in the wrong places performance help?

THank you,

STank
stankstankAsked:
Who is Participating?
 
QPRCommented:
You may get more luck in the .NET group
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/ASP_DOT_NET/

You can put a pointer in that group pointing to this post (I'm told)
0
 
QPRCommented:
Multiple conn strings will chew up server memory as each instance of the conn object is created and it's methods exposed. Would the read/write part not be more applicable to the recordset object?

0
 
stankstankAuthor Commented:
>> Would the read/write part not be more applicable to the recordset object? <<
I don't know or understand the question.  I have read that a connectionstring for reading and one for writing is better because the database uses them differently and can handle each more efficiently.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
QPRCommented:
I may be getting mixed up between classic ASP (before .NET) and it may be different now but.....
In ASP the "connection" object was the tunnel that ran between your page/app and the datasource.

The "recordset" object was the vehicle that retrieved the data from the datasource.
This recordset object came in different flavours, read only or updateable etc
0
 
stankstankAuthor Commented:
i don't know, but I am using .NET.  I believe the recordset object is classic ASP.
0
 
stankstankAuthor Commented:
Any sql server experts want to take a shot at this one?

stank
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.