Pinning multiple rows in radgridview is significantly slow (openedge)

[n/a]

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?

 

[Dinko | Tech Support Engineer]

Hello Philip,

Thank you for reaching out to us.

To be honest, I am not fully familiar with the specifics of the ABL language and the OpenEdge environment. Nevetheless, I have tried to follow your steps and prepare a sample project in WinForms. The RadGridView control contains 280 rows with 100 columns. You can test in on your side. Run the project and click the Reset button. It creates new data and is applied to the control. I could not observe a longer loading time as the one described in your post.

It seems that this behavior could be related to the environment. As I mentioned above, I am not fully familiar with the specifics of the ABL language. I would suggest submitting a technical question in Salesforce or the Progress Community, which is the preferred platform preferable for OpenEdge-related topics. You can log in to these websites straight from your Progress account: https://progresslink.progress.com/supportlink.

Regards,
Dinko | Tech Support Engineer
Progress Telerik