I was paranoid in using session scope in previous versions...especially with large amounts of data...plus in CFMX the session data can be replicated in a cluster.
Cheers, Stace -----Original Message----- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 03, 2002 6:08 PM To: CF-Talk Subject: RE: browsing large recordsets - cursors? What is the difference with CFMX that allows you to kill the session scope? Wasn't this possible in earlier versions? Brook At 05:45 PM 03/08/02 -0400, you wrote: >I've got a heavy reporting app which used query caching on large recordsets >(10K-20K rows at times) with no isssues... > >Now that I'm on CFMX I've moved the data in session scope so I can kill it >as soon as it's not needed....appears to be a good deal more efficient... > >Stace > >-----Original Message----- >From: Brook Davies [mailto:[EMAIL PROTECTED]] >Sent: Saturday, August 03, 2002 5:00 PM >To: CF-Talk >Subject: browsing large recordsets - cursors? > >Hello y'all, > >In an application which allows forward / backwards browsing of large >recordsets (10,000-25,000) and access to individual records details, how is >this best handled with CF? > >I am currently caching the query and then displaying the rows within each >screen. But this means that the large recordset is held in memory, and this >seems a bit inefficient. Is there a better way to browse records like this? >I've heard MSSQL Cursors might be a solution to this problem. Does anyone >know of CF/CURSOR resources? Is this a good/bad idea? > >Thanks for your input. > >-Brook >Brook Davies >President >maracasmedia inc >www.maracasmedia.com >logiforms / logiworks software inc. >www.logiforms.com > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
