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 > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
