Million Records Problem

Hot Topic

Unabel to connect to SQL 2005 Analysis Services in SQL Management Studio
Proxy account not responding
Error using Datareader Destination
General error handling
Assisted Editor for stored procedures
Email reports based on a condition
Combine Data and Split into separate txt files for each header/detail row groupings
Limit Report Server Access
Merge disparate queries into raw file
mac sql2005 express

SQL Server

2005 SP1 (remote Reporting Services upgrade failures)
DTS Mail task breaks after SQL 2005 uninstall/install
Preventing recalculating page breaks on printing of database diagrams?
Downgrade Install Plan
SSIS package fails on execution
Report Project and Report Designer
Can't save package to Server (No description found) ERROR - Again
Can't install SQL2005 (unexpected failure)
Debugging stops without messages
Task to create and drop tables

Million Records Problem

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...




Answer this question

Million Records Problem

  • Optimistic1954

    You should set the report to execute from a snapshot, otherwise each user access results in another 1M rows put into memory.

  • p4praveen

    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
  • Million Records Problem
Answer this question