Well, lots of options. At present I am using mainly BXML/Backbase.
-----Original Message----- From: Wayne Putterill [mailto:[EMAIL PROTECTED] Sent: 23 January 2006 16:24 To: CF-Talk Subject: Re: storing query results while paging through As a side note to this, what are the options for paging with regards to Ajax or Flash these days? I'm just wondering if there is something out there that I should be considering for future use. On 1/23/06, George Abraham <georg [EMAIL PROTECTED]> wrote: > All, > I don't use session variables at all, but this might a good time to use > them. > > I have a search page that takes in a search term, runs a query and then > displays the results. The user is allowed to click into a result and then > page through the search resultset while in a result (via Previous/Next > controls). Since I don't store the query results anywhere, I basically run > that query every single time that the user presses Previous or Next (just so > that I can find out where the user is while s/he is paging through and what > the previous and next results are.) For an intensive search (which this is > turning out to be), this means every time that the user does anything with > the resultset, I am running a 4 or 5 second operation. Highly inefficient, I > suspect. > > How do I cache the query results? Is a session variable the best option? I > guess cookies would not be bad, but they are limited in the amount they can > hold. How do people tackle this problem anyway? > > Thanks, > George > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54