Thanks James, that makes fair sense, I'll check my connection pooling setting and have a play around, I'll let you know how I get on.
Rob -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 11 August 2008 11:55 To: CF-Talk Subject: Re: Database Sessions CF does conenctions two ways: 1) CF uses pooled connections if you have maintain connections checked for the datasource, This means a connection will stay open for quite some time, across multiple web requests. 2) If you don't maintain connections, CF opens a connection at the first cfquery tag and keeps it open until the request ends, so that all the queries in a single request use the same connection. So, at the very least, you should be able to use your temporary table for everything in the page. On Mon, Aug 11, 2008 at 5:42 PM, Robert Rawlins <[EMAIL PROTECTED]> wrote: > Morning guys, > > Does anyone know how ColdFusion handles opening and closing a database > session? Is it for every cfquery tag set? Or for every cftransaction tag > set? Or is it less predictable than that? > > The reason I ask is that I've been looking at using temporary tables in a > procedure, as I understand it, SQL Server creates these in a session local > variable. I need to know how long the temporary table will be accessible to > me in this session scope, can it spread across multiple queries? Or just the > single one?. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4