We have a RadGridView that's data-bound to a DataView (via ItemsSource). The DataTable can have 1 million records or more and we're sometimes experiencing out-of-memory errors, and memory never seems to be freed. Typical column count for our grid is anywhere from 10 or so to maybe 20+. The more columns, the worse, of course.
The grid is on a WPF UserControl that's hosted inside a WinForms form, in case that makes a difference, and it's set up to auto-generate columns because it's designed to show practically any kind of data from the database that the user wants to query. We have column and row virtualization enabled, and we're using the lightweight templates (which we recently implemented because they're faster).
We really have 2 problems:
1. Memory usage versus the standard .NET data view control. Are there any known issues with excessive memory usage?
2. Memory never seems to be released, even after disposing the DataTable, setting references to null, removing the grid from its parent, disposing the disposables, and other things we've tried. This hurts because even if each of the user's query returns less than a million rows, it adds up over time and the grid doesn't seem to release memory for what was there before.
Thanks for any help.
The grid is on a WPF UserControl that's hosted inside a WinForms form, in case that makes a difference, and it's set up to auto-generate columns because it's designed to show practically any kind of data from the database that the user wants to query. We have column and row virtualization enabled, and we're using the lightweight templates (which we recently implemented because they're faster).
We really have 2 problems:
1. Memory usage versus the standard .NET data view control. Are there any known issues with excessive memory usage?
2. Memory never seems to be released, even after disposing the DataTable, setting references to null, removing the grid from its parent, disposing the disposables, and other things we've tried. This hurts because even if each of the user's query returns less than a million rows, it adds up over time and the grid doesn't seem to release memory for what was there before.
Thanks for any help.