image\cslogo3d1.gif

Pooling Database Connections

In terms of server resources, accessing a database is one of the most expensive operations of a Web application. Typically, for each request, the Web application must open a connection to the database, retrieve the data, and then close the connection. Repeatedly opening and closing the database in this manner negatively impacts server performance.

To reduce this impact on server performance, you can configure the Chili!Soft ASP Server to share open database connections among multiple users who are accessing the Web application. This is called database connection pooling. With connection pooling, rather than opening and closing a database connection for each individual request, the ASP Serveruses a connection that is already open. Database connection pooling dramatically improves the performance of applications that rely heavily on database operations.

To configure database connection pooling, use the procedure in "Setting the ADO Connection Pool Size" in this chapter.

Copyright 2001 Sun Microsystems, Inc. All rights reserved. Legal Notice.