Pinning multiple rows in radgridview is significantly slow (openedge)

1 Answer 21 Views
GridView
n/a
Top achievements
Rank 1
n/a asked on 09 Apr 2025, 12:25 PM

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?

 

1 Answer, 1 is accepted

Sort by
0
Dinko | Tech Support Engineer
Telerik team
answered on 10 Apr 2025, 11:40 AM

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

Enjoyed our products? Share your experience on G2 and receive a $25 Amazon gift card for a limited time!

Tags
GridView
Asked by
n/a
Top achievements
Rank 1
Answers by
Dinko | Tech Support Engineer
Telerik team
Share this question
or