Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Multiple ConnectionStrings & Performance

Posted on 2006-06-18
6
Medium Priority
?
191 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

610 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