How to Improve Download spped

[Stressed_Simon]

Then I would definietely archive it in a .cfm file then you can just cfinclude
it which will be lightning compared to how you do it now. CFM files get
compiled so can be added to files via cfinclude with very litle overhead.

[Coldguru]

I do not know how to archive . can you give me more details related to archiving to a file.

[Stressed_Simon]

Well instead of creating the excel spreadsheet, save all the html that you use
to output it into a variable. Then use cffile to save it as a .cfm file. Then
when someone calls your spreadsheet then you can just cfinclude that instead of
the database call and that will spead up the process.

The best way to do this would be to run a scheduled task that update this file
everyday.

If there are any specifics that you do not get then let me know and I'll go
into it in more detail.

[Stressed_Simon]

Also bear in mind that this is never going to be superquick as 40k records is a lot of byes of info which have to be downloaded.