Setting the ADO Connection Pool Size

Sun ONE Active Server Pages supports database connection pooling, which improves the performance of applications that rely heavily on database operations. With connection pooling, rather than opening and closing a database connection for each individual request, Sun ONE ASP uses a connection that is already open.

Sun ONE ASP uses an ADO control to provide database connectivity. The ADO connection pool size parameter is set in the Sun ONE ASP Administration Console. The default ADO connection pool size is 25, which can be increased or decreased according to your requirements. There is no maximum number of connections that can be pooled. Setting this to 0 (zero) disables connection pooling.

Open the Administration Console (see Accessing the Administration Console).

On the ASP Server tab of the Server Management page, click Databases.

Click the ADO Settings tab.

The ActiveX Data Object Connection Setting page displays.

In the Connection pool size box, type the number of connections you want to pool.

Click Save, and then click Server Management in the left navigation pane.

Restart the ASP Server by clicking Restart.

Note	Restarting the ASP Server resets all Session and Application variables.