paul smith wrote:
> 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)
probably, show us your code... you should only need structkeyexists and
never structfind
anyway quasi code
<cflock timeout="4" throwontimeout="No" type="READONLY" scope="APPLICATION">
<cfif NOT structkeyExists(application,"search")>
<cfset application.search=structnew()>
</cfif>
<cfif structkeyExists(application.search,search_string)>
<cfset qry_search=duplicate(application.search[search_string]>
<cfelse>
<cfsearch name="qry_search" criteria="#search_string#">
<cflock timeout="5" throwontimeout="No" type="EXCLUSIVE"
scope="APPLICATION">
<cfset application.search[search_string]=qry_search>
</cflock>
</cfif>
</cflock>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
