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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-05-23 : 05:35:30
|
| Hi, Why is it the report always runs very slowly the first time the user runs it. But all the next runs are much quicker? Is there a way to reduce the time the report is run for the user the first time? Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-05-23 : 06:40:24
|
| If you are talking about Reporting Services, I think it is due to caching issues, the easiest way is to pre run the report for them, this way it is already cached. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-05-23 : 06:49:49
|
| Is it ok, to pre-run just one simple report every so often so that the SSRS engine doe snot fall sleep due to IN-Activity? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-05-23 : 07:03:48
|
| Well, in the options somewhere, when you set up RS, you will have a time to keep cached reports, can't remember, but think its in the admin area somewhere. This setting will keep a cached copy of the report for as long as asked for assuming there is enough memory on the server assigned to the cache. |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-05-23 : 07:29:14
|
| I think for my issue, if I schedule a simple report to run every few minutes, then the ssrs engine will not fall sleep and thefore when a user runs one of the many reports, then he will not be delayed in teh report being displayed.At present if there is in-activity on the ssrs then the first person to run a report early in th emorning is faced with a long delay but any subsequent reports will be fine. |
|
|
|
SQL Basic
Starting Member
8 Posts |
Posted - 2012-05-30 : 23:07:29
|
| You can setting up the pre run time with specific value. |
|
|
|
|
|
|
|
|
slow report first time