This is a migrated thread and some comments may be shown as answers.

Dynamic Sorting Calls The Data Source

1 Answer 107 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Majar
Top achievements
Rank 1
Majar asked on 11 Apr 2019, 04:51 PM

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

1 Answer, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 16 Apr 2019, 09:03 AM
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
Tags
General Discussions
Asked by
Majar
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or