> Is there a way to keep a database connection alive? I know
> you can do that in ASP, etc, but the standard <cfquery> tag
> opens and closes the DB connection with the execution of the
> SQL statement.

By default, database connections are pooled and reused. They aren't opened
and closed with each CFQUERY tag. You can configure how this works within
the datasource settings in the CF Administrator.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to