Solved

Multiple ConnectionStrings & Performance

Posted on 2006-06-18
6
184 Views
Last Modified: 2008-02-20
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
Comment
Question by:stankstank
  • 3
  • 3
6 Comments
 
LVL 29

Expert Comment

by:QPR
ID: 16932578
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
 

Author Comment

by:stankstank
ID: 16965566
>> 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
 
LVL 29

Expert Comment

by:QPR
ID: 16965741
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

Author Comment

by:stankstank
ID: 16968110
i don't know, but I am using .NET.  I believe the recordset object is classic ASP.
0
 

Author Comment

by:stankstank
ID: 16978440
Any sql server experts want to take a shot at this one?

stank
0
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 16979925
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now