In my experience with storing recordsets in cached structures, subsequent reading records from the structure was slower than reading the same records from a cached query.
Is this expected behavior, or did I screw up? (first time again) best, paul At 04:29 PM 12/13/02 -0500, you wrote: > > One thing to check is whether CFSEARCH allows caching > > (Studio doesn't think it does, which agrees with my > > recollection). If your app is as amenable to caching > > queries as www.SMARTERyellowPages.com is, then your > > choice may be clear. > >While you can't use CACHEDWITHIN or CACHEDAFTER attributes with CFSEARCH as >you can with CFQUERY, you can certainly cache a recordset from CFSEARCH by >storing it in a persistent variable. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm