Dynamic Sorting Calls The Data Source

2 posts, 0 answers
  1. Majar
    Majar avatar
    13 posts
    Member since:
    Nov 2018

    Posted 11 Apr Link to this post

    Hi

    We're using dynamic column sorting in telerik report. But every time we click on the sort button the report calls the data source. Is there a way to avoid it. This happens when we render the report in different format(csv, pdf) too.

     

    Regards,

    Majar

  2. Neli
    Admin
    Neli avatar
    84 posts

    Posted 16 Apr Link to this post

    Hi Majar,

    I assume that the sorting is performed with an Action. In this case each time the actions gets executed the report will be re-processed and re-rendered and the data will be fetched again during this process. This behavior is by design, as storing potentially huge data will occupy huge memory and may reduce the overall performance of the server.
    Note that the already rendered documents are cached, hence if you request the same report with the same parameter values in the same export format, it will be taken from the storage.

    As a workaround, you may introduce an ObjectDataSource which will fetch the data from the original data source (e.g. database) and cache it for reuse.

    Regards,
    Neli
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top