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,

Who is Participating?
QPRConnect With a Mentor Commented:
You may get more luck in the .NET group

You can put a pointer in that group pointing to this post (I'm told)
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?

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.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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
stankstankAuthor Commented:
i don't know, but I am using .NET.  I believe the recordset object is classic ASP.
stankstankAuthor Commented:
Any sql server experts want to take a shot at this one?

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.