So, it was a select * into app scope?
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Rick Root To: CF-Talk Sent: Fri Mar 16 12:33:15 2007 Subject: Re: cfqueryparam vs val( ) On 3/16/07, Peter Boughton <[EMAIL PROTECTED]> wrote: > > > Whilst this does prevent you from caching queries using the built-in > attributes, it doesn't prevent you from caching them manually. > > eg: Something along the lines of this: > <cfif NOT (StructKeyExists(Session,'Bob') AND DateDiff('h', > Session.BobCreated, Now()) LT 1)> > <cfquery name="Session.Bob"> > ... > </cfquery> > <cfset Session.BobCreated = Now()/> > </cfif> I've actually found that caching queries like that for VERY commonly used queries can actually be a performance drain... For example, I used to load our "code table" into the application scope. I used this code table all over the web site.. anytime I needed to turn "MI" to "Michigan" or "010" to "Athletics"... I'd run a simple udf... getAdvanceCode(tablid, tablkey) and it would output the appropriate value. But the code table itself is VERY large... 78,000 records I found that querying the database directly actually took less time than doing a query of queries... particularly when doing large numbers of such queries. Databases handle queries of large record sets far better than coldfusion does. Rick -- > Join the Open Source Coldfusion NCAA Pool for a chance to win a 2 gig USB > flash drive! > http://www.opensourcecf.com/forums/ncaapool.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
