Is there any way or approach on handling reports with million of records retrieved?
Had a problem for 25 silmultaneous users accessing the report.
Problems are:
- Timeout Expired.
- Server unavailable.
- Page cannot be displayed.
Please let me know if there is... Thanks in advance...
You should set the report to execute from a snapshot, otherwise each user access results in another 1M rows put into memory.
|||I am curious... why do your users want to see all million rows? Is it possible to reduce the amount of data coming into the report server by pushing filters down into the query expressions?
No comments:
Post a Comment