If you've got a query like that, why store it in the SESSION? Store it in the Application scope. Store it once and you're done.
<!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Jeff Guillaume [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 23, 2006 3:11 PM To: CF-Talk Subject: Re: Sorting by Column Headers Storing the results in SESSION is a nifty (and fast) method, but I'd only recommend it if you know your result sets will always be relatively small. You don't want 100 people caching a resultset of, say, 10,000 rows of data. You'll run into memory issues. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
