Data Access and Transactions

Tips for Optimizing Database Connections

One of the main challenges of designing a sophisticated Web database application is maintaining a properly managed database connection. Opening and maintaining connections, even when no information is transmitted, can deplete a database server’s resources and result in connectivity problems. Well-designed Web database applications manage connections wisely and compensate for delays due to network traffic.

Here are six tips to help you optimize your use of database connections:

• Tip 1: Enhance Performance on SQL Server Systems
• Tip 2: Set the Connection Time-Out
• Tip 3: Close Your Connections
• Tip 4: Share Active Connections
• Tip 5: Restrict Connections Across Pages
• Tip 6: Increase the Size of the Record Cache

© 1997-1999 Microsoft Corporation. All rights reserved.