Cache pages
Hello,
I have been testing this feature and I am not sure that it does what I
think it does. Basically I have two requests from an end-user...
1) Improve the performance over a slow network.
2) Decrease the time taken to print from preview.
On reading the help the cache pages feature appears to be adapted to what I
want to do, but on testing I have see
- no difference in the performance.
- no difference on the SQL access.
I has previously tested this on 5.56 and it was indicated that this feature
didn't work correctly but would be okay in version 7.01. I am currently
using version 7.02. Can you indicate is this feature works correctly in
version 7.02 ?
And if so why I might no be seeing any difference in DB access or
performance.
thanks
Alex
I have been testing this feature and I am not sure that it does what I
think it does. Basically I have two requests from an end-user...
1) Improve the performance over a slow network.
2) Decrease the time taken to print from preview.
On reading the help the cache pages feature appears to be adapted to what I
want to do, but on testing I have see
- no difference in the performance.
- no difference on the SQL access.
I has previously tested this on 5.56 and it was indicated that this feature
didn't work correctly but would be okay in version 7.01. I am currently
using version 7.02. Can you indicate is this feature works correctly in
version 7.02 ?
And if so why I might no be seeing any difference in DB access or
performance.
thanks
Alex
This discussion has been closed.
Comments
The CachePages property works as designed in ReportBuilder 7. One item to
keep in mind is that the report pages are not being cached untill they are
inititally viewed for the first time. For instance, if you view pages 1 -
30 of your report then decide you want to see page 5 again, with the
CachePages property set to True, the report engine will not have to go back
and access the data and completely regenerate page 5, the page will already
be in memory. This is where you will see the largest speed increase with
this feature.
Another thing you can try to speed things up a bit would be to turn the
Report Outline off.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com