I've got a radgridview consisting of approximately 280 rows and 100 columns (some non-visible), made by autogenerating columns based on a dynamic temp-table in the datasource. After opening the query I'm setting for approximately 15 rows the Ispinned property to true:
radGridView...:Rows[i]:PinPosition = Telerik.WinControls.UI.PinnedRowPosition:TOP.
Based on the information the profiler provides, this takes around 7 seconds per call. This is way to slow since the program has to recreate the dynamictemp-table and associated information by querying the database each 30s.
The pinning of the rows is already encapsulated by a beginupdate on the grid table element. Setting certain properties to false of the grid didn't result in a speed up.
What did make the pinning of the rows faster was when the query had less rows.
How could this be faster? Is it possible to pin the rows while the query is retrieving its results or before instead of after?