Microsoft reporting services report taking too much time with huge data

I am using Microsoft SQL reporting for reporting but facing problem because I have huge amount of data, from huge i mean 100000 to 1000000 records. When i retrieve records it joins 8 tables, So I want to know is Microsoft reporting is feasible with this amount of data as i have read articles that it slow downs performance or is there any other option like Crystal Reports or any other component?

My query is in a stored procedure and i fill that in a DataSet.xsd and then use it on my page using ObjectDa开发者_如何学JAVAtaSource to bind it with report. Another thing is I have to use charts component as well in reporting. Im using Sql server 2008 R2 standard version with Asp.Net 4 application.

I really doubt your users are looking at 1 million or even 100k records - and you mention the chart control as well. If you are needing to give them flexible aggregations, consider adding SQL Server Analysis Services to your reporting server and building a cube from your online data. An Excel add-in can be used to crunch numbers - it's pretty slick.

Perhaps you need to build more reports and procedures that do specific filtering or aggregation. Creating reports with that many rows is going to cause problems.

If you could explain what your users do with all that data, maybe there could be a better answer.

You can run the query below to find out:

SELECT Name, TimeDataRetrieval,TimeProcessing,TimeRendering
    , TimeDataRetrieval+TimeProcessing+TimeRendering AS TotalTime,Format,Parameters,username,TimeStart
FROM dbo.ExecutionLog L WITH (NOLOCK)
    INNER JOIN dbo.Catalog R WITH (NOLOCK) ON L.ReportID = R.ItemID
WHERE Name='' -- update parameters for report name
AND Format>'' 
ORDER BY Name

TimeDataRetrieval is how long the query takes to execute.

Try to run the same query from Management Studio on the same client and compare the execution time of both.