Hi All,
We are facing performance issues for report export.
When the report is exported from windows application (c# 2.0) , time it takes is about 10 mins for 100 records.
When same report is executed directly from browser (via report viewer) , it takes about 1 min only.
Now, below is our NEW architecture:
>ReportServer and ReportServerTempDB databases are on Server A.
>Our main DB's which reports refer are on Server B.
Before this, all the DB's were on same server and the reports would export in 1-2 mins.
My Question:
1.Does the NEW architecture causing this delay ??
2. Are there any report server level settings which can improve this export execution from win app (like http execution timeout etc...)
If any pointers/suggestions, will be helpful
Regards.