I have to create some reports (SSRS) that I thought I would use just storedProc to sever the purpuse, however, the stored proc are taking a more than a 1 min and 50 secs in sql server management studio. This has been resulting in timeout at the report server. These storedProc should read back about 800.000 records. Now, that Im thinking of creating a dataMart and a cube of that to better the performance. Is this something I should even consider, is there any alternative. Any suggestion will be appreciated.
-------------------------- Joins are what RDBMS's do for a living
If you are returning 800,000 rows to a front-end, I'm not sure that it'll matter which technology you use. But, regardless of how many rows you are returning we don't have enough information about your setup/system to offer a suggestion one way or the other.