Database Sessions
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?. Any ideas? Cheers, Rob ~| 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:310680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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:310688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Database Sessions
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
RE: Database Sessions
Rob, With pooled connections you can force a request to stay on one connection by wrapping your queries in cftransaction. Otherwise, CF can and will swap connections on you right in the middle of processing a request, and your temp tables will go away. Jaime -Original Message- From: Robert Rawlins [mailto:[EMAIL PROTECTED] Sent: Monday, 11 August 2008 9:01 PM To: CF-Talk Subject: RE: Database Sessions 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?. -- ~| 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:310780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
