Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xhostx
Constraint Violating Yak Guru
277 Posts |
 Posted - 2013-03-29 : 11:41:41
|
| 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.Thanks!--------------------------Joins are what RDBMS's do for a living |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-03-29 : 12:19:28
|
| 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. |
 |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2013-03-29 : 13:37:06
|
| what would you need to know?Thanks!--------------------------Joins are what RDBMS's do for a living |
|
|
|
|
|
|
StoredProc Vs SSAS performance