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 adversely impacts server performance.

To reduce this impact on server performance, you can configure the Sun 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, the ASP Server uses a connection that is already open, rather than opening and closing a database connection for each individual request. 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.