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

Reply via email to