I recently built reports using Reporting Services 2005 and I integrated them into a web application. The report have been running fine until I imported a lot of data into my database. That when problems started and I have now to wait more than one hour for the report and other times the report server hangs up. When I take the query I use to Management Studio it takes up to 10 seconds to run.
Initially I was returning 600 to 1000 rows (1-2 seconds) and now I return more than 80000 rows. Can some one help please?