Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

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
0
stankstank
Asked:
stankstank
  • 3
  • 3
1 Solution
 
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
 
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now