All I want to do is, store the results returned by >a query somewhere in
memory so that if the search returns more than 100 records (100 records are
displayed per page), when >the 'next' button is clicked.. instead of running
the query/stored procedure again.. just get the information from the memory>
variable.
Hi,
I've not been following this thread but from what you say above, surely you
could simply cache the queries and use a blockfactor to speed things up a
bit.
<cfquery name="blah" datasource="blah"
cachedwithin="#createtimespan(0,0,5,0)#" blockfactor="100">
Though, for large resultsets and large numbers of searches this could pose
problems unless you have plenty ram available on the server.
HTH,
Dave
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
