Last post Apr 09, 2012 11:10 AM by adamturner34
Apr 09, 2012 11:04 AM|ramesh866|LINK
i am getting lakhs of record from sql db and i want to store in excel which will be used be user. i know ways to get and insert data into excel. but i want to consider performance , since the records are huge. so what is the best way to retrieve and store
huge data in excel .
Apr 09, 2012 11:10 AM|adamturner34|LINK
Well my first suggestion would be considering filtering the data down into smaller resultsets if possible.
Secondly and realistically, large resultsets are large resultsets and take time to move regardless of the methodology or technology. With that idea in the forefront, it is reasonable for the user to request such large amounts of data in a spreadsheet format?