>On Thu, Apr 17, 2008 at 8:38 AM, James Smith <[EMAIL PROTECTED]> >wrote: > >> If I remember correctly if you have CF maintaining connections your >> temp table will hang around almost indefinitely, best practice would >> be to DROP it once you are done with it. >> >> >> Well I did some tests... and I determined that the table *DOES* get >deleted at the end of the request... that's good. Basically I ran a query >that created a temp table, then I ran another request that selected from >that temp table and it wasn't there .. so either it got deleted at the end >of the request, *OR* the second request was a separate "session" and thus CF >couldn't see the original temp table. > >Either way, that's good. > >rick
For temporary data manipulation, in general, "variable table", is more efficient than creating temporary tables, however, there are two exceptions where one can't use this technique. You may consider BOL for more detail. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
