Re: The search is killing the server. Please help!

[cf coder]

Thank you all for your help. I really appreciate it. I've taken Hugo's advise (thank you Hugo) and gone with "session" scope route. I'm storing the results in a session variable. I'm not caching anything, it just adds more complexity to a already complex solution.

Here is the code for anyone who is interested:

<!--- first time a user performs a search --->
<cfif NOT IsDefined('session.searchresults') and isDefined("url.DELETESESSIONINFO")>

<cfquery name="session.searchresults" datasource="#request.dbName#">
   EXEC iSearch blah blah...
</cfquery>

<!--- If the user does another search (new search) I'm deleting the session info --->
<cfelseif IsDefined('session.searchresults') and isDefined("url.DELETESESSIONINFO")>

  <cflock scope="SESSION" timeout="10" type="EXCLUSIVE">
    <cfset temp = structdelete(session,"searchresults")>
  </cflock>
  
  <cfquery name="session.searchresults" datasource="#request.dbName#">
     EXEC iSearch blah blah...
  </cfquery>
</cfif>

<cfoutput group="DatTime" query="session.searchresults" startrow="#start#" maxrows="#display#">

  <!--- output the columns --->

</cfouput>

Many thanks again for all your help
regards,
cfcoder

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---