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
