Hi everybody,
I am trying to present a very large chunk of data to users via a web page.
The query takes 45 seconds to run (optimized) in the Query Analyzer and
yields 100,000 records.
Good 'ol CFOUTPUT will not work. IE chokes if there are more than 5,000 or
so records. It takes so long for the page to render.
I am wondering if anybody else has been here before and has any suggestions
?
Perhaps :
- Have SQL output a flat file and point to that with CF.
- Write to an Excel file with an ODBC Driver ?
- Explore CFX_Excel
- Limit view to 5,000 at a time.
Thanks for any pointers.
Jonathan Woodcock
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
