hi, i would like to bump this thread as i have the same question.
i need to be use a spreadsheet of about 60,000 rows, is this going to be an issue? thanks > Hi folks - > > I am looking for some people who have used this tag or have created > spreadsheets > with a larger data set (more than 200 records). > > CFSpreadSheet works fine with under 100 records, but when you start > going above 200, 500, or even 700 records, the systems grinds to > almost a halt, and it kills the processor. > > When I am adding rows to a spreadsheet, using - > SpreadsheetAddRows(schedRpt, myQuery) > > I notice my processor utilization spike, and then take forever to come > down > when I use that tag. > > Any and all ideas on how to create a spreadsheet with a large amount > of data quickly? > > All ideas are appreciated. > > Thanks, > > Doug > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

