We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

InsertRange poor performance

Thread ID:

Created:

Updated:

Platform:

Replies:

76948 Sep 30,2008 12:45 PM Oct 16,2008 04:33 PM Windows Forms 2
loading
Tags: GridControl
Tim Mostad
Asked On September 30, 2008 12:45 PM

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 [Syncfusion]
Replied On October 1, 2008 03:34 PM

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
Replied On October 16, 2008 04:33 PM

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;