| Author |
 Topic  |
|
|
arkiboys
Flowing Fount of Yak Knowledge
1341 Posts |
 Posted - 05/23/2012 : 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
United Kingdom
3560 Posts |
Posted - 05/23/2012 : 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
Flowing Fount of Yak Knowledge
1341 Posts |
Posted - 05/23/2012 : 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
United Kingdom
3560 Posts |
Posted - 05/23/2012 : 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
Flowing Fount of Yak Knowledge
1341 Posts |
Posted - 05/23/2012 : 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
Canada
8 Posts |
Posted - 05/30/2012 : 23:07:29
|
| You can setting up the pre run time with specific value. |
|
|
| |
Topic |
|
slow report first time
