InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
When You Do Not Use Report Caching, Is It Better To Use Parameters To Filter Information In The Query Or To Use Filters In The Dataset? |
|
Answer» From a performance perspective, it is better to USE PARAMETERS because they let SSRS PULL filtered data from the data source. In contrast, when you use filters, the queries retrieve all data and then filter the information in an ADDITIONAL STEP. From a performance perspective, it is better to use parameters because they let SSRS pull filtered data from the data source. In contrast, when you use filters, the queries retrieve all data and then filter the information in an additional step. |
|