InsertRange poor performance

[Tim Mostad]

The following line in a custom grid control derived from GridControl is consuming 73% of the time in a critical section of code:

Me.Rows.InsertRange(CInt(RowLocation), 1)

InsertColumn is also very slow. Is there some way to improve performance?

[Administrator]

Is the InsertRange call being done repeatedly? If so, you might try bracketing your calls with BeginUpdate/EndUpdate to see that makes things faster.

Me.BeginUpdate()

'do all your inserts...
Me.Rows.InsertRange(CInt(RowLocation), 1)
'...
Me.Rows.InsertRange(CInt(RowLocation), 1)
'...

Me.EndUpdate()
Me.Refresh()

Another thing you might try is to set:

OptimizeInsertRemoveCells = True

[Tim Mostad]

Both of these made a huge difference in the performance of my app. Thanks!