Performance Issue

[sakthi.s]

Hi All,
Wishes for the day.
I'm generating a report in Excel and saving it. The report takes more than 5 mins to generate the output. where my client wants me to show hte output in <1min.
There are more than 45000 records and after i save the file size crosses 65MB in my hard disk.
ANy 1 help me to solve this. Please reply me if you require any more inputs regarding this.

Thanks in Advance.

[blom0344]

I think you are using the wrong technology here. If you have output in the range of several tenthousand rows than you would be better of writing the intermediate results to a table and directing Excel to this source. You are using a BI reporting tool as a semi ETL solution. It is just not meant to be used that way, hence the less than ideal performance..