I have a big Report with a lot of objects ( > 100'000) get processed in a report. This works fine on the first time but the memory usage is very high. (>200mb). I inspected a lot of possible reasons and found out that the all my objects in the datasource for my report get cached by the reportviewer. As i'm loading the data from a database after interaction from a user (filter, export etc.) i don't need this cache.
Because of the cache the memory is not getting released until the cache is released and that could be a long time. So if i run my report multiple times i got in trouble with the high memory usage ( > 2.5 GB).
What can i do? I tried to move the cache (http://www.telerik.com/help/reporting/configuring-telerik-reporting-session-state.html
) to the file system but this is not working as expected.