The default behavior of ODBC connections created through CF Admin is to keep
connections open. This is done to avoid the overhead of repeatedly opening
and closing the connection on a per call basis. When this option is turned
off, via the checkbox in the connection configuration, a new connection is
opened and then closed for every call to a DSN. This is less efficient but,
can be useful when a particular DSN is used infrequently or to avoid locking
problems with file based dbs, like Access. This can be helpful in
development environments. In situations where you have a template or app
that is called infrequently but uses a large number of connections you may
want the best of both worlds, i.e. a persistent connection for the life of
the template/app/session that drops when finished. A possibility is to see
if the call that CF Admin makes to clear all connections can be tailored to
only drop an individual connection. You could then leave your connections in
persistent mode and drop them on demand :)
Steve
> From: [EMAIL PROTECTED]
> Reply-To: [EMAIL PROTECTED]
> Date: Mon, 10 Jul 2000 11:25:38 -0700
> To: [EMAIL PROTECTED]
> Subject: Force database connections to close....
>
>
> Hello all,
> It looks like CF doesnt like to release the
> data brought down, which hogs up on the memory.
>
> Is there a way to force the database connection to close or to
> release memory as data is dumped to the client..???
>
> some like connection.close()
>
> This would really be a powerful feature to have...
>
> Any ideas
>
> Thanks
> Joe
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the
> body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
