Skip to content

DBAzine.com

Sections
Personal tools
Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.
Who Are You?
I am a:
Mainframe True Believer
Distributed Fast-tracker

[ Results | Polls ]
Votes : 3568
 

Comment

Above in this comment thread: Connection Pooling and Connection Management

Thank you

Posted by OurCurrentFuture at 2006-04-28 11:13 AM
I just wanted to thank you for this article, particularly the part about not caching database connection objects.

I have been having a problem with an application and was not able to find any information on whether caching the connection affected connection pooling or not. Seems like it does and I'll be sure to put that change in and keep it in mind for the future.

Wayne
http://blog.ourcurrentfuture.com

conflicting pooling ideas

Posted by guerven at 2006-12-04 03:36 AM
Question 1: True or False: Changing the connection string, even slightly, will force a new connection.
False.

You don’t believe me? You’re a skeptic. Good. This is a common misconception. Many sources report that modifying even a single space in your connection string will force new connections to be created. While it is true that modifying the credentials of a connection string will create a new connection, shuffling the parameters around will not. SQL simply verifies that the user, password, and database are the same for a connection request to be eligible for pooling.

source
http://www.sql-server-performance.com/sk_connection_pooling_myths.asp






ano ba kuya! ano ba talaga!


 
Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper
Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!
 
 

Powered by Plone