Setting up data sources + connection options

[jenn1]

Hi,
When setting up a data source in CF Administrator, under the Advanced Settings, does anyone know what the following options are for:
Limit Connections:
Maintain Connections (we were asked to never check this)
Max Pooled Statements
We need to limit our connection pool. For some reason the CF server and our data base server don't close connections after an application has closed. Is there a way to minimize the connection pool?

[Newsgroup_User]

From the Help pages:

Limit Connections: If selected, limits the number of data source connections
to the value entered in the Restrict Connections To field.

Maintain Connections: ColdFusion establishes a connection to a data source
for every operation that requires one. Select this option to improve
performance by caching the data source connection.

Max Pooled Statements: Enables reuse of prepared statements (that is, stored
procedures and queries that use the cfqueryparam tag). Although you tune
this setting based on your application, start by setting it to the sum of
the following:

Unique cfquery tags that use the cfqueryparam tag

Unique cfstoredproc tags

--
Ken Ford
Adobe Community Expert - Dreamweaver
Fordwebs, LLC
http://www.fordwebs.com


"jenn" <webforumsuser@macromedia.com> wrote in message
news:fre2gi$4u4$1@forums.macromedia.com...
> Hi,
> When setting up a data source in CF Administrator, under the Advanced
> Settings, does anyone know what the following options are for:
> Limit Connections:
> Maintain Connections (we were asked to never check this)
> Max Pooled Statements
> We need to limit our connection pool. For some reason the CF server and
> our
> data base server don't close connections after an application has closed.
> Is
> there a way to minimize the connection pool?
>