sorting in data bound grid

[Randy Furtado]

we have a data bound grid that updates at a high frequency. we have noticed that once you sort one of the columns in the grid everything slows down.

we believe this is because all new updates are causing internal sorting on the grid. so as to keep the rows sorted.

for our grid of 4000 rows by 40 columns the performance difference is significant.

is there a way we can just "static" sort the data bound grid? i.e. sort once and then not have the internal sort run as new updates come in.

we will then be forced to sort again but at least our grid update performance will be acceptable.

[Administrator]

To do this, you have to bypass the default sort behavior of a GridDataBoundGrid. By default, the grid just reflects the data in teh datasource. So, when it gets sorted, the CurrencyManager and its associated DataView reflects teh sort. So, anytime you change a value in teh sorted column, the DataView sorts it to its proper place.

So to avoid this autosorting, you have to not use teh default sorting support of teh datasource''s currencymanager and associated dataview. This takes a little effort. Here is an initial try at this. It may take some tweaking to get it to work in your application. It assumes your datatable has a primary key column to facilitate looking items up.

http://www.syncfusion.com/Support/user/uploads/GDBGCustomSortingFiltering_69f8cf69.zip