Hi Admins
Previously i was using Default DataGridView for populating a Table.
It was working fine. But due to advace Functionality of RadGridView, I have develop the same with Telerik Controls (R2 SP1 2019).
But i have some Performance Issues.
Check the Sample Code and please suggest me for Performance Enhancement.
I'm Creating Column at Run Time Using This Code and Setting Grid Properties.
this.radGridView1.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;this.radGridView1.ShowGroupPanel = false;this.radGridView1.MasterTemplate.EnableGrouping = false;this.radGridView1.EnableHotTracking = true;this.radGridView1.MasterTemplate.SelectionMode = GridViewSelectionMode.FullRowSelect;this.radGridView1.AllowAddNewRow = false;this.radGridView1.AllowEditRow = false;GridViewTextBoxColumn ColumnId = new GridViewTextBoxColumn{ Name = "suppid", HeaderText = "Code", FieldName = "suppid", Width = 80, HeaderTextAlignment = ContentAlignment.MiddleCenter, TextAlignment = ContentAlignment.MiddleCenter };radGridView1.MasterTemplate.Columns.Add(ColumnId);
I'm creating 10 different Columns using the Above Code.
Using the Below Code loading the Data to GridView
DataTable dt = new DataTable();string query = "Select suppid from p_supplier" ;SqlCommand cmd = new SqlCommand(query, Conn);SqlDataAdapter DA = new SqlDataAdapter(query, Conn);DA.Fill(dt);BindingSource source = new BindingSource();source.DataSource = dt;radGridView1.MasterTemplate.DataSource = source;
I have shown you only 1 Column only to shorten my Code.
Please Suggest.
54 Answers, 1 is accepted
Rank 1
According to the provided code snippet, it seems that you populate the columns in RadGridView programmatically. I suppose that the AutoGenerateColumns property is set to false. Thus, when you set the RadGridView.DataSource, the already added columns will be used. Everything seems to be pretty straight-forward. That is why it is difficult to determine what causes the performance problems that you mentioned.
Could you please specify how many rows you load in RadGridView?
If you have a large number of rows in the grid, it would be good to consider using RadVirtualGrid. It is a grid component developed on top of Telerik Presentation Framework which provides a convenient way to implement your own data management operations and optimizes the performance when interacting with large amounts of data: https://docs.telerik.com/devtools/winforms/controls/virtualgrid/overview
However, if you insist on using RadGridView, I would kindly ask you to submit a support ticket and provide additional information how to replicate the undesired behavior that you are facing. A sample project would be very useful for further investigating the case. Thus, our support staff will gladly assist you.
Note that most of the forum threads are reviewed by Telerik representatives and sometimes we address the questions asked by our customers in the forums as well. However, a post in the forum doesn't guarantee you a response from the Telerik support team. Moreover, threads are handled according to license and time of posting, so if it is an urgent problem, we suggest you use a support ticket, which would be handled before a forum thread.
Thank you for your understanding.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Rank 1
Thanks for your kind reply.
Yes i populating the data programmatically with AutoGenrateColumns=False.
Right now the grid only populate 300 Rows.
I will try to use VirtualGrid.
Can you Guide me How can i Populate the Grid only after Form is Fully displayed on screes.
Rank 1
radVirtualGrid1.BeginUpdate(); radVirtualGrid1.EndUpdate();
Required Little Explanation for this Code of lines.
These are used at Many places in the Demo provided.
Does this help to overcome performance Issues.
Thanks
Indeed, using RadGridView.BeginUpdate and RadGridView.EndUpdate methods are the suitable approach for improving performance when adding multiple rows programmatically. Note that when you add a row, this will refresh the grid. Hence, if you add 300 rows, 300 refresh operations will be performed. But it is not necessary. You need to refresh just once after the last row is added. That is why call the RadGridView.BeginUpdate method before adding the rows and the RadGridView.EndUpdate method after adding the rows which will suspend the layout while you are adding rows and only at the end the grid will be refreshed.
I hope this information helps.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Rank 1
Hello,
I just found this thread.
2016 I tried Telerik Grid and it had a performance issue handling loaded data.
Now I just tried the 2020 version and simple replaced an old MS DataGridView winform control with a RadDataGridView.
Assigned the same BindingSource and nothing else
MS DataGridView is a bit faster before displaying it, that's o.k.
But why does the sort of a columns, I clicked in the header, seems to still takes lightyears compared to DataGridView.
The same data source takes a few seconds maximal with DataGridView and RadDataGridview is hanging now the whole time I'm writing this reply.
Until now my PC is consuming high CPU and not sorted still.
Amount of records. 60936, not a high amount
Stefan
Hello, Stefan,
According to the provided information, it wouldn't be easy to determine what exactly causes the sorting performance problem on your end. Please have in mind that RadGridView has a much richer features set compared to the MS DataGridView. Hence, even though we strive to optimize as much as possible RadGridView, it may not provide the same performance as the MS DataGridView in some cases.
The sorting performance depends on the number of records as well as the column's values. Usually, it is expected to observe slower sorting with 100 000+ records. However, if the column's values are almost identical, you may also experience some undesired behavior. There is a way to speed up the sorting on the columns by accessing the internal logical class of the data layer. There is a Threshold which when set to a smaller value will change how sorting is executed internally:
RadDataView<GridViewRowInfo> dataView = this.radGridView1.MasterTemplate.DataView as RadDataView<GridViewRowInfo>;
HybridIndex<GridViewRowInfo> indexer = dataView.Indexer as HybridIndex<GridViewRowInfo>;
indexer.Threshold = 500;
Another option that I can suggest is to set the grid's data view BypassSort property of the true. This way you will prevent the built-in data sorting mechanism in the grid to be executed while still have a visual indication. In this kind of setup, the sort descriptors can be directly applied to the underlying data source object. Please check the following documentation article providing an example: https://docs.telerik.com/devtools/winforms/gridview/sorting/basic-sorting
An alternative solution that I can suggest is using RadVirtualGrid. It is a grid component developed on top of Telerik Presentation Framework which provides a convenient way to implement your own data management operations and optimizes the performance when interacting with large amounts of data. Additional information how to populate the virtual grid with data and use the sorting feature is available in the following help articles:
https://docs.telerik.com/devtools/winforms/controls/virtualgrid/sorting/sorting
Feel free to use this approach which suits your requirements best. However, if you are still experiencing any further difficulties, I would recommend you to submit a support ticket from your account and provide a sample project demonstrating the problem you are facing. Thus, we would be able to investigate the precise case and think about a suitable solution.
I hope this information helps. If you need any further assistance please don't hesitate to contact me.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.
Rank 1
I replaced a fast working winform DataGridView control displaying 60000 rows with ~ 10 columns with a RadGridView.
In detail
Mouse: Delete control, toolbox: Add control, property Datasource: existing ProBindingSouce, that's all.
https://knowledgebase.progress.com/articles/Article/How-to-improve-performance-of-RadGridView-sorting
I know you want to point all the time the sorting to external but this means all, every single of the rich feature, has to be programmed in the data layer and I need to reload all data again and again having in memory already?
The data was loaded completed and then i don't want to use the data layer anymore for such a small amount of data.
I can scroll through all rows without problems.
Again, DataGridView can do the same in a part of a second and I needed to kill the process because your control uses 100% cpu and after 40 minutes one col isnn't sorted still. Fourty minutes!
There is a bug!
We are not talking about much data, 60000 rows (4 zeros) isn't so much to sort them in memory.
Something is going wrong and I can't get it why nobody else raise it.
I know that many OpenEdge users are using Infragistics still but you should minimum offer the same performance like the free GridView in .NET
Rank 1
So, I found a "bug" or incompatibility between a property of the ProgressBindingSource.
It's needed to set to true having a sort possibility in DataGridView.
But if you only replace the control and use Telerik the result is a mass.
Disabling it increase the sort speed dramatically but still not the same as with DataGridView.
Rank 1
Rank 1
I just tried Infragistics, doesn't have the same speed like DataGridView but after 15 seconds i get a column sorted
Hello, Stefan,
I am really sorry to hear that you are not satisfied with the sorting performance that RadGridView provides in combination with ProBindingSource. Indeed, 60 000 rows are not so many records and RadGridView does sort almost instantly in a sample WinForms project. Please refer to the attached gif file. However, it is a specific scenario when using RadGridView with a ProBindingSource.
We had similar reports from other OE clients in the past and we did confirm an issue regarding the sorting performance. Here is the forum post with a similar discussion for your reference: https://www.telerik.com/forums/sorting-data-is-very-slow---5000-records)
Considering the internal data management mechanism in RadGridView and the specificity of the internal implementation of the ProBindingSource, we have come to a possible solution for this particular case to introduce the BypassSort property. This is specifically introduced for working with ProBindingSource. I understand that it may require some additional coding from your side but it is the possible solution that we can offer for the ProBindingSource scenario.
An alternative solution for improving the sorting performance is to consider using RadVirtualGrid which is a grid component developed on top of Telerik Presentation Framework and provides a convenient way to implement your own data management operations and optimizes the performance. However, it would involve extracting the respective data records every time a new sort action is performed. Additional information how to populate RadVirtualGrid with data and achieving sorting the data is available in the following help articles:
https://docs.telerik.com/devtools/winforms/controls/virtualgrid/sorting/sorting
Feel free to use this approach which suits your performance considerations best. Should you have further questions please let me know.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.
Rank 1
Hello,
"Indeed, 60 000 rows are not so many records and RadGridView does sort almost instantly in a sample WinForms project."
o.k., your are right, it should be fast and now? Doing nothing?
Is it so complicated for your development to compare DataGridView behavior with yours?
As you are now belonging to Progress since years, can't your development not take a look why it's not working as it should?
You got more than one complain and do: Nothing?
Why DataGridview is a rocket and other grids with OpenEdge snails?
It's annoying that I'm forced to write code what DataGridView can do out of the box and we maybe pay for?
For millions of records I can accept that the data in memory makes no sense but I expect that your control can do minimum the same as DataGridView.
Rank 1
The Microsoft DataGridView needs the Progres BindingSource Property= True.
This seem to be the magic property and both controls fit together.
https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dvref%2Fautosort-property.html%23wwID0EYFHPB
Can you explain me why your sorting is so slow with the Progress BindingSource?
You get the data fast, you have it in your control, why a sort is such a bottleneck?
I'm surprised that a Grid, I think one of the most used control, does not work within one company out of the box.
I like to have multiple col sorting and grouping, all features which are available.
All possible features with less data, and 60000 rows IS less data.
So I'm forced to rewrite the query during events, something I expected to get it out of the box.
" we have come to a possible solution for this particular case to introduce the BypassSort property."
What about? BindingSourceType = OpenEdge
Can't find this property Bypass, where is it? I have the latest version installed.
Rank 1
Please refer to the attached gif file.
This is the behavior I expect!
Why not with the development within your own company???
Can't you tell the OpenEdge team what thy have to change?
Rank 1
Hi Dess,
i surrender and started to implement the easy code for sorting, using example:
https://knowledgebase.progress.com/articles/Article/How-to-improve-performance-of-RadGridView-sorting
Con you check it please what is needed to get a fast sorted result?
It's faster but it takes a long time (minutes) to get the data from bindingsource into the grid after re-open the query.
First time it's fast.
//Stefan
Hello, Stefan,
I would like to note that this particular case (RadGridView + ProBindingSource) have been deeply discussed with developers on both sides, Telerik developers and OpenEdge developers. I completely understand your frustration but, to be honest, it is not only the RadGridView control to be blamed for the performance. The ProBindingSource also has its own specifics that affect the internal data management in RadGridView. I understand that you are using OpenEdge and Developer Studio, please note that for OpenEdge related topics the preferred places to submit a technical question are Salesforce and the Progress Community. You can log in to these websites straight from your Progress account: https://progresslink.progress.com/supportlink
Please have in mind that RadGridView and MS DataGridView have completely different internal implementation. RadGridView also provides much more features compared to the MS DataGridView. This involves more complex internal data management.
That is why as a conclusion of our communication with OpenEdge developers we have come to a solution that is appropriate for covering the scenarios of both sides, Telerik clients and OpenEdge clients. I would like to specify that RadGridView doesn't have any specific code which is different when using a ProBindingSource. We provide the same RadGridView implementation for all of our clients. Indeed, the BypassSort property will require writing some code which is not so much I believe. It is just necessary to sort the data source by a give column. Please refer to the Bypass default sorting section at the end: https://docs.telerik.com/devtools/winforms/controls/gridview/sorting/basic-sorting
An alternative solution is to benefit the custom sorting functionality that RadGridView offers. There is also a public KB article that the OpenEdge support engineers gladly prepared to cover such cases: https://knowledgebase.progress.com/articles/Article/How-to-improve-performance-of-RadGridView-sorting
Another option is to consider using RadVirtualGrid. Indeed, it would involve much more code writing, but it is expected to provide the best performance.
Thank you for your understanding and I strongly believe that the suggested solutions would cover acceptable sorting performance for your case.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.
Rank 1
Hi Dass,
maybe you missed but I surrendered already at used the code from the KB. (they used a demo table with a few records)
"It's just necessary to sort the data source by a give colum" - I did, not complicated for sorting, grouping I don't know in the moment.
But it doesn't work well still, needs now instead of (>30 min) "only" up to 2 minutes.
Something is missing, like icing the cake or there is a bug.
I tested query with "BY .." from the beginning -> fast, it's not the query!
Somehow there is a problem to refresh the data in the grid from the updated query behind the binding source.
I set this now on top:
this-object:radGridView1:MasterTemplate:DataView:BypassSort = true.
and have handler for
radGridView1_CustomSorting and radGridView1_SortChanging
The result is correct, needs much time only.
One additional note:
OpenEdge has a big bottleneck named Bridge, this is the link between .NET objects and ABL code, it's slow and everybody should prevent to transfer much data from ABL to NET objects. Keeping and sorting data within a .NET object is faster if possible and size is not so much.
I'm continuing now with the OpenEdge support, maybe they know what is wrong with the example and current versions.
//Stefan
It seems that while I was preparing my previous reply, you posted the last message. Please excuse me for any misunderstanding.
I would like to note that if you set the BypassSort property to true, there is no need to use the custom sorting. Simply set the sort order for the source collection in the SortChanged event as it is demonstrated in the last section of the following help article: https://docs.telerik.com/devtools/winforms/controls/gridview/sorting/basic-sorting
You will notice that custom sorting is not used at all in this case. The sorting performance will depend on the time for sorting the source collection directly. I believe that you will obtain performance that will be suitable for you.
I hope that you will come to an appropriate solution after contacting the OpenEdge support. Please have in mind that if you have any further questions regarding the Telerik controls, please don't hesitate to contact us.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.
Rank 1
I tried this too and failed.
1 Looks like the same performance problem I have without any own code too.
2 It fires the event only on the first clicked column, for others I need to click twice
3 Setting Sort to "" throws exception
this-object:radGridView1:MasterTemplate:DataView:BypassSort = true.
method private void radGridView1_SortChanged( input sender as System.Object, input e as Telerik.WinControls.UI.GridViewCollectionChangedEventArgs ):
// no reaction if BindingSource.AutoSort = false (default)
if (e:Action = NotifyCollectionChangedAction:Add or e:Action = NotifyCollectionChangedAction:ItemChanged) then
do:
define variable s as SortDescriptor.
s = cast(e:NewItems[0],SortDescriptor). // why fix 0, getting every time the first clicked column??
define variable sortOperator as character.
if (s:Direction = ListSortDirection:Ascending)
then
sortOperator = "ASC".
else
sortOperator = "DESC".
this-object:bsTransfer:Sort = s:PropertyName + " " + sortOperator.
end.
if (e:Action = NotifyCollectionChangedAction:Remove) then do:
this-object:bsTransfer:Sort = ?. // does throw exeception, not implemented
end.
end method.
I have an easy question:
Don't you have any OpenEdge installation where you can try yourself this nice control interaction with a progress BindingSource having more data in the grid then 30 records?
It's not so complicated ;-)
When I try the Progress solution, should be like refreshing the grid every time, why it's slow still? It should be fast like the first fill.
It's faster but a mass still compared to the initial run.
How to clear the grid in a fast way without losing the sort/group icons?
If you don't have OpenEdge why not installing an OEDK version? It's for free in case you have a budget problem.
Even Microsoft did this for .NET ODBC bugs!
And then you can provide - maybe - a solution and get rid of me.
I have a parallel open progress case and waiting now since 1 week for a solution from their side.
Maybe you can win the medal still ...
Hello, Stefan,
I am glad that you have contacted the OpenEdge support as well since I believe that it is a suitable approach for this case as the OE support can provide the best possible assistance with the ProBindingSource and any difficulties that you are experiencing with it regarding performance.
We usually use a C# equivalent of the ProBindingSource that the OE developers have already provided if it is necessary to test any scenario on our end. I am not sure how complete this implementtaion is but is good enough for simple tests. That is why I setup a sample project with RadGridView with 3 columns and 60000 records. The ProBindingSource uses a DataTable as a data storage. I know that the difference in the sorting time between using a ProBindingSource and a DataTable is massive. But any core logic in both internal implementations, RadGridView and ProBindingSource, isn't so easy as it looks. Both products have been for a very long time on the market designed to cover the main scenarios of the target customers groups for which they are developed. Hence, any changes in the data management are very dangerous and sometimes not even possible.
By default, if the rows count is less than 10 000 we use quick sort to order the items. If there are more items we use Red-Black tree. This is controlled by the UseHybridIndex property.
(radGridView.MasterTemplate.ListSource.CollectionView as GridDataView).UseHybridIndex = false;However, both of the algorithms use non-linear data access. If the ProBindingSource is not optimized to get data not linearly, which I believe the OE support engineers could give more information about, the performance wouldn't be satisfactory.
That is why we have introduced the BypassSort functionality to cover this case after cooperation with the OE developers. Thus, our RadGridView won't perform any logic for sorting and the whole time necessary for sorting will depend on the DataSource itself (ProBindingSource in your case) and how this collection sorts its items.
With the current implementation and data management in RadGridView we are not able to introduce any appropriate solution except the BypassSort mechanism. However, the important part here is that I can confirm after my tests that it doesn't work as expected and as it should be. After introducing the BypassSort property, we also introduced the BypassFilter property due to the same reasons. Both properties are false by default. Hence, if you set only the BypassSort property to true, sorting logic still will not be skipped until you set the BypassFilter to true as well. This information is missed in our online documentation and we will update it accordingly. However, they should work separately without affecting one another.
That is why I have logged it in our feedback portal by creating a public thread on your behalf. You can track its progress, subscribe for status changes and add your comments on the following link - feedback item.
I have also updated your Telerik points.
Currently, the possible solution that I can suggest you to try is to enable the BypassFilter property as well in your project. It would be greatly appreciated if you can share the obtained result with us and whether you noticed any performance changes. Thank you in advance for your cooperation.
Along with creating a public feedback item for the confirmed issue with the BypassSort, I will create a new private support ticket on your behalf. You can find it in your Telerik account - Ticket ID: 1468461. Its purpose is to keep any further communication private since we are intending to introduce a fix as soon as possible and we would like to provide you the dlls containing the potential fix before releasing the Latest Internal Build. Thus, we will confirm that the fix would be suitable for your scenario.
Thank you in advance for your patience and understanding.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.
Rank 1
Veteran
Rank 1
Veteran
Hello Stefan,
the same problem at my end, since 2016.
Do you have any solution?
Regards Marc
Btw. I can't see my post below in Chrome?!
Rank 1
Hi Marc,
current status:
RadGridView has nearly the same performance like the cost free basic NET control DataGridView when sorting a column.
This was possible since 2016 with manual code on the ABL side but then somehow destroyed and it looks like Progress (OpenEdge quality team) has no check for this on nightly builds.
With latest Telerik version it's working again.
Filtering, I never tested, but I hope it will be the same as Sorting only by building a manual query.
The main problem, from Telerik hotline side nobody seems to have an OpenEdge installation and I got so many hints which would make it more worse like using VirtualGrid. This is maybe fine for .NET but for ABL a mass as each single record needs to be marshalled and transferred through this bridge.
The last option, grouping, was ignored for months. I asked many times but it seemed to be they have a filter on both sides.
If I get a bad report on a control I would run a full check on all options but seems to be Q&A thinks different.
Progress knows from 2015 or longer that RadGrid and PBS are not fine together, introduced q&d new option and ignored grouping on purpose!
NOW, finally after my bothering, somebody at Progress OpenEdge support made a performance check for grouping and they failed completely - of course.
NO solution, no workaround!
A new option shall be introduced to fix it - only for grouping.
I asked for rewrite the binding source to work properly for all but no, only one option.
Telerik fixed the control within days until they understood they added a regression bug.
OpenEdge team put it on the open item list for 12.3, this means maybe next year???
Since 2016 it's known and they delay again - their own products!!
It should be fixed in 12.2 (long term version) and 11.7, we are using this still.
It's a bad joke to propose 12.3 only.
Workarounds from others are: Own user control in C#
//Stefan
I would like to note that we introduced a fix in R2 2020 SP1 (LIB 2020_2_603) regarding the BypassSort and BypassFilter properties that RadGridView offers. Feel free to upgrade to this version in order to benefit from the fix.
These two properties are specifically designed to handle the cases with OE ProBindingSource. It is necessary to set the BypassSort property to true. This way you will prevent the built-in data sorting mechanism in the grid to be executed while still have a visual indication. Then, subscribe to the RadGridView.SortChanged event and sort directly the DataSource. The sorting performance will directly depend on the DataSource itself. In this kind of setup, the sort descriptors can be directly applied to the underlying data source object, e.g. ProBindingSource in this case. Please check the following documentation article (section "Bypass default sorting") providing an example: https://docs.telerik.com/devtools/winforms/gridview/sorting/basic-sorting
Please have in mind that for OpenEdge related topics, the preferred places to submit a technical question are Salesforce and the Progress Community. You can log in to these websites straight from your Progress account: https://progresslink.progress.com/supportlink Thus, the OE support engineers would gladly provide the appropriate assistance. Thank you for your understanding.
I hope this information helps.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Rank 1
Veteran
Hello Stefan,
I have another workaround, I'm using Microsoft DataTable to bind to the RadGridView.
It's much more work, but all features of RadGridView works fine and the performance is great.
The downside is I can't use AutoUpdate of BindingSource, I have to search the entry of my temp-table.
Not only the RadGridView is lazy with OpenEdge, i.e. I can't use Pivot, because OpenEdge isn't multithreaded.
Thanks a lot for your answer.
Regards Marc
Hi, Marc,
RadGridView can be bound not only to a MS DataTable. It can be bound to different collection types listed here: https://docs.telerik.com/devtools/winforms/controls/gridview/populating-with-data/databinding-radgridview
I would recommend you to consider using a BindingList which provides additional control over list items, i.e. if they can be edited, removed or added. BindingList also surfaces events that notify when the list has been changed: https://docs.telerik.com/devtools/winforms/controls/gridview/populating-with-data/binding-to-bindinglist
RadGridView is capable of fetching bindable properties and data. However, one important issue must be noted: during the data binding process, the grid extracts the data from the data source, but for any later changes in the data source, RadGridView should be notified. Your bindable collection and business objects should follow some standards established in .NET in order to notify RadGridView about the changes:
- The collection that you will bind to RadGridView should implement IBindingList or IBindingListView interfaces. This will allow RadGridView to get notified about insert and delete operations of records.
- Your business objects should implement INotifyPropertyChanged interface (.NET 2.0). This will allow RadGridView to reflect changes which occur to the properties of the business objects.
A complete example is demonstrated in the following help article: https://docs.telerik.com/devtools/winforms/controls/gridview/populating-with-data/reflecting-custom-object-changes-in-rgv
An alternative approach that is worth considering, instead of using RadGridView, is using RadVirtualGrid. It is a grid component developed on top of Telerik Presentation Framework which provides a convenient way to implement your own data management operations and optimizes the performance when interacting with large amounts of data. You can achieve the best possible performance (regarding UI) during sorting with it: https://docs.telerik.com/devtools/winforms/controls/virtualgrid/overview
Should you have further questions please let me know.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Rank 1
Hi Marc,
sure, you can use Datatable, List, etc.
But how you got the data from OpenEdge into a datatable in a fast(!) way?
Import from a json file(stream), export takes time.
Same issue for Lists...
//Stefan
Rank 1
Veteran
Hi Stefan,
I'm all with you on this one. I think it's very uncomfortable to use for OE.
I'm thinking, a little more time to prepare the data (tt to DataTable) is better than drinking a coffee while sorting...
It's hard to write it in english what I want to say, need a german forum ;)
Regards Marc
Rank 1
... dann mal auf Deutsch (gibt ja translator)
Wie hast du die Daten in DataTable bekommen? JSON Import?
Und wieviele Records sind es bei dir?
Es wäre zu schön DataTable aus einem PDS zu füllen ...
Wenn du kein Grouping nutzt, sind die Workarunds ganz o.k.
Wobei es ein Witz ist Lizenzen zu bezahlen um etwas Langsameres zu bekommen, wo man auch noch von Hand eingreifen muss.
Rank 1
Veteran
Ich habe die Fragen verstanden, nur alles in englisch wiederzugeben was mir so durch den Kopf geht, ist nicht ganz einfach.
Was hast du für einen Translator ins Deutsche benutzt, das sieht nämlich nicht nach Übersetzer aus.
[quote]Stefan said:
Wobei es ein Witz ist Lizenzen zu bezahlen um etwas Langsameres zu bekommen, wo man auch noch von Hand eingreifen muss.
[/quote]
Absolute Zustimmung, wie von dir in einem früheren Post schon erwähnt, sollte es nach all der Zeit auch möglich sein, die Komponenten mit den Standard OE-Komponenten zu verwenden.
OE bietet einige Restriktionen was die OOP angeht, aber wenigstens die Grundfunktionalitäten hätte man an Telerik anpassen können nach all den Jahren.
Mich nervt es absolut, dass ich z.B. kein Pivot nutzen kann, ein mächtiges Werkzeug, dass mir einfach nicht zur Verfügung steht.
Zur Sache mit dem DataTable.
Ich nutze im Designer immer eine BindingSource, nur so lässt sich das Grid entsprechen anpassen ohne alles später händisch im Quelltext zu machen.
Ich habe nur zwei Wege, Weg 1 funktioniert aber nicht in allen Fällen.
Variante 1
DEFINE VARIABLE oDataSet AS DataSet NO-UNDO.
DEFINE VARIABLE lcData AS LONGCHAR NO-UNDO.
FIND FIRST tt-RefiAuslauf NO-ERROR.
dsAuswertung = ?.
IF AVAILABLE tt-RefiAuslauf THEN DO:
BUFFER tt-RefiAuslauf:WRITE-XML("longchar", lcData, TRUE, ?, ?, TRUE).
ASSIGN oDataset = NEW DataSet().
IF NOT VALID-OBJECT(dsAuswertung) THEN
dsAuswertung = NEW System.Data.DataTable().
oDataSet:ReadXml(NEW System.IO.StringReader(lcData), XmlReadMode:InferTypedSchema).
dsAuswertung = oDataSet:Tables[0].
END.
gvAuslauf:DataSource = THIS-OBJECT:dsAuswertung.
Variante 2
Zuerst mal die Struktur herstellen (Beispiel mit einem Feld).
DEFINE VARIABLE vEilig AS System.Data.DataColumn NO-UNDO.
vEilig = NEW system.data.datacolumn('Eilig', System.Type:GetType('System.Boolean')).
Utils.ObjectUtils:DeleteObject(dsAuswertung).
dsAuswertung = NEW System.Data.DataTable().
dsAuswertung:COLUMNS:ADD(vEilig).
Und dann über ein FOR EACH füllen.
dsAuswertung:Clear().
FOR EACH tt-BearbVertragsservice BY tt-BearbVertragsservice.VID:
drow = dsAuswertung:NewRow().
drow['Eilig'] = tt-BearbVertragsservice.eilig.
dsAuswertung:Rows:Add(drow).
END.
dsAuswertung:EndLoadData().
radGridView1:DataSource = THIS-OBJECT:dsAuswertung.
Rank 1
Hatte beide Varianten 2016 getestet und es war zu langsam.
Die erste Variante sollte eigentlich immer funktionieren, diese hatte ich kürzlich nochmal getestet und als zu lahm verworfen.
Teste doch mal die Workarounds, im Prinzip funktionieren diese ganz passabel.
Rank 1
Veteran
Man kann damit arbeiten, zumindest das Sortieren funktioniert ganz passabel.
Habe mir jetzt noch nichts zum Filtern gebaut, dass muss dann ja auch manuell gemacht werden.
Nervige Arbeit...
Hello, Stefan and Marc,
I am really happy to see an active discussion between customers in the forum.
However, I would kindly ask you to use English which is the official language for communication in the Telerik WinForms community. Thus, the community can also benefit from your discussion in future.
Thank you for your understanding.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Rank 1
Neverending story continues ...
Sorting: Acceptable performance (not a rocket with 70000 records) reopen the query with a BY statement in the SortChanged event and set MasterTemplate:DataView:BypassSort = true (had a regression bug since ?, fixed with 2020.2.616.
Filtering: I expect the same like sorting - no code avail in the moment
Grouping: No solution until got OE 11.7 SP7, setting SyncToSelectedRow of the Bindingsource to false in GroupChanging and back to True in GroupChanged (now acceptable speed but still not a rocket)
But it looks like QA department and dev stopped after getting this result.
I tested to sort the group (click on the grouped button) and sorting a column in the grouping.
Both failed with a long runtime (> minute(s))
I really hoped I got with SP7 a solution where this grid works fine and didn't expect to find a problem within minutes.
It's frustrating, I think a grid is the most used control in applications. (assemblies workaround - really?)
I am glad that the introduced fix in R2 2020 SP1 (2020.2.616) by the Telerik WinForms team regarding the sorting functionality leads to acceptable performance when sorting: https://feedback.telerik.com/winforms/1468456-radgridview-bypasssort-doesn-t-improve-sorting-the-rows-when-openedge-probindingsource-is-used-as-datasource
However, regarding the grouping perfomance, the OpenEdge team was expected to introduce a fix related to the ProBindingSource (case number is 00820556). After collaboration between the Telerik WinForms team and the OpenEdge team nothing was expected to be changed in RadGridView's implementation. If I am not mistaken, the fix should have been already released. Have you tested it with the latest OE version? Have you discussed the obtained result on your end with the OpenEdge support engineers in the respective case that you have on this topic?
Indeed, RadGridView is one of the most commonly used controls in the Telerik UI for WinForms suite. However, with small amount of data, we haven't had any performance reports by other customers using the grid in a standard WinForms application in .NET environment. It seems that the problematic behavior was only in OpenEdge environment, because RadGridView relies on OE ProBingingSource component in order to load its data.
I would like to encourage you to consider trying the RadVirtualGrid control as it is expected to give you the desired grid UI. Any data operations like sorting, filtering, grouping (achieved by hierarchy) are managed by the developer. Hence, the performance depends entirely on the used external collection and how you extract the data itself:
https://docs.telerik.com/devtools/winforms/controls/virtualgrid/overview
https://docs.telerik.com/devtools/winforms/controls/virtualgrid/working-with-data/virtualgrid-populating-with-data
https://docs.telerik.com/devtools/winforms/controls/virtualgrid/sorting/sorting
https://docs.telerik.com/devtools/winforms/controls/virtualgrid/filtering/filtering
https://docs.telerik.com/devtools/winforms/controls/virtualgrid/hierarchical-virtual-grid/hierarchical-data
I hope this information helps. If you need any further assistance please don't hesitate to contact me.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Rank 1
Hi Dess,
I hope your are fine in these strange times.
The OE fix was released, I tested it, and - unfortunately - I found new issues.
Grouping is fast(er) now but it seems to be overseen the sorting of the group or a column in the grouping.
Both options need a long time and I couldn't test this before without the fix.
"Small amount of data", a colleague of you meant "70000 records is 'nothing' for the RadGridView, even 1 million can be handled."
And in the part I tried to use it we have usually < 100000 records.
Every code managed by the developer in Openedge which access .NET controls/objects, are time consuming because of the needed data marshaling between the two technologies. My known goal is to avoid OE(ABL) code creating objects row by row.
When I tested grid controls longer time ago, I ran a test with a colleague, creating datarow objects. He created > million of them (C#) and, if I remember well, I got a few thousands in the same time using the same code logic.
I'm waiting now for the reply of OE support about my findings.
Regards
Stefan
I am glad to hear that you have contacted the OE support engineers and shared the observed groups sorting behavior after introducing the fix regarding the ProBindingSource. I believe that they will provide further assistance on this topic.
As to the question about the number of records, 70 000 rows are considered to be a normal number of records for RadGridView. Usually, with any other DataSource (except ProBindingSource), we haven't complains from our customers and they observe very satisfying performance when it comes to sorting, filtering, grouping, etc. You can also consider testing RadGridView in unbound mode and compare the grouping and sorting speed in this scenario: https://docs.telerik.com/devtools/winforms/controls/gridview/populating-with-data/unbound-mode
However, 1 000 000 is quite a lot for managing with the RadGridView's internal infrastructure. That is why we offer RadVirtualGrid which was previously mentioned. RadVirtualGrid can deal with a practically unlimited number of records which makes this control a better option when dealing with a large amount of data. Our Demo application >> VirtualGrid >> Performance example is quite a good demonstration.
Should you have further questions please let me know.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive, special prizes, and more, for FREE?! Register now for DevReach 2.0(20).
Rank 1
Hi Dess,
our expected amounts of records will be not more than 100000, a normal number as you mentioned.
I tried unbound in the past but failed with the marshaling bridge between OpenEdge and .NET objects.
Creating objects by OpenEdge code costs much time and needs to be avoided in loops.
The general rule is, try to have no loops, avoild manual code and get the data controlled by controls only including sorting/grouping/...
Regards
Stefan
Hi, Stefan,
I understand your concerns about using unbound mode. 100 000 records in RadGridView are actually not a small number of records. But it is manageable for the grid in .NET environment and it produces acceptable and stable sorting and grouping performance on our end.
However, to be honest, there is not much to be done in RadGridView's implementation if the main problem is the marshaling bridge between OpenEdge and .NET objects. No matter what UI control you are using, the performance may not be acceptable enough.
The best that we can offer in Telerik UI for WinForms suite as a UI component that produces good performance is the already mentioned RadVirtualGrid. It doesn't perform any data operations and it just requests data values to be passed in the CellValueNeeded event. It is up to the developer how and from where this data is extracted and sorted.
If I can assist you with anything else related to the Telerik UI for WinForms suite please don't hesitate to contact me.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Five days of Blazor, Angular, React, and Xamarin experts live-coding on twitch.tv/CodeItLive, special prizes, and more, for FREE?! Register now for DevReach 2.0(20).
Rank 1
Veteran
Hello,
any new informations on this?
Regards
Rank 1
Morning,
did you notice I opened this discussion just yesterday? ;-)
Meanwhile Telerik added new properties which are helpful to be used from the OpenEdge side.
But my smoke test (months ago) failed at once because it covers not all combinations.
The discovered failure was sorting grouped lists, OpenEdge support should be in discussion with the Telerik team - i hope.
If this will be fixed the Grid probably is usable from OpenEdge with more data than "100 rows"
Hello, Marc,
As the status of the previously mentioned feedback item indicates, the improvement in RadGridView that involves the control itself was introduced in release R2 2020 SP1 (LIB 2020_2_603): https://feedback.telerik.com/winforms/1468456-radgridview-bypasssort-doesn-t-improve-sorting-the-rows-when-openedge-probindingsource-is-used-as-datasourceSince this issue concerns both, RadGridView and OE ProBindingSource, the OpenEdge team was also expected to introduce a fix related to the ProBindingSource. The original SalesForce case is Number 00820556 "Major performance issues when simply replacing a MS DataGridView with Telerik RadGridView".
As Stefan replied earlier in this thread, in OE 11.7 SP7, with setting SyncToSelectedRow of the source to false in GroupByChanging and back to true in GroupByChanged the performance was improved.
After further investigation of the discussion about sorting and grouping scenario a new SalesForce case was created - case number 00873238 "Performance issues when combining Sorting and Grouping with Telerik RadGridView"
As a result of this case and discussing the case with OpenEdge, as of R1 2021 RadGridView offers two new events:
- GroupSortChanging: Fires when the user changes the sorting of the group. The action can be canceled.
- GroupSortChanged: Fires after the user has changed the sorting of the group.
You can also use these new events to manage the SyncToSelectedRow property. You can set SyncToSelectedRow to FALSE in the GroupSortChanging event and then back to TRUE in the GroupSortChanged event. I believe that this approach is applicable for the GroupByChanging/GroupByChanged and SortChanging/SortChanged events.
If after applying the suggested approach in the latest version of the Telerik UI for WinForms suite and OpenEdge you are still experiencing any further difficulties with the sorting/grouping performance, I would recommend you to submit a SalesForce case providing details about your precise case and a sample project illustrating the problem you are facing. You can log in to these websites straight from your Progress account: https://progresslink.progress.com/supportlink
I hope this information helps. If you need any further assistance please don't hesitate to contact me.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
Rank 1
"Number 00820556 "Major performance issues when simply replacing a MS DataGridView with Telerik RadGridView"."
Interesting, my finding result but it's not listed in my cases ...
Until today I'm waiting for OpenEdge Support do deliver a solution...
// Stefan
Rank 1
Noticed 00820556 - this is my OpenEdge case, not a Telerik case, very confusing.
This case is still open since months, it's up to OpenEdge support (Fabio) to run a final sanity test and to approve it as working fine.
Hello, Stefan,
Indeed, the referred case numbers are actually SalesForce cases. In other words, these are cases that you have opened to the OpenEdge support.
Since we are working in collaboration, very often it is necessary to discuss customer cases in order to provide the best possible solution to a client that is using Telerik UI for WinForms in OpenEdge environment.
I have discussed this with Fabio and he assured me that a knowledge base article with a proper example is about to be introduced which is expected to provide tips and guidance how to properly setup RadGridView with a ProBindingSource to produce as good performance as possible.
Stay tuned with further information on this topic in the SalesForce cases.
Should you have further questions regarding RadGridView please let me know.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
Hello, all,
I would like to follow up with this KB article that was just released by the OpenEdge support: https://knowledgebase.progress.com/articles/Knowledge/How-to-improve-performance-of-RadGridView-sorting-and-filtering
Its purpose is to demonstrate the possible options for optimizing RadGridView during sorting, filtering, grouping when it is combined with ProBindingSource.
I believe that you will find this resource helpful.
Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.
Rank 1
Veteran
Hello,
nice to have a whitepaper for this issue, but it's just a workaround.
I hope that will be fixed in one of the next releases.
Regards
Rank 1
Hello,
this article reflects the result of my very long discussions with the Telerik/OpenEdge support.
The good news, it's now somehow possible to get sorting/filtering/grouping with more data than 1000 records.
The bad news, you have to do filtering and sorting by code (not a complicated thing), grouping seems to be done by the control but when you start to combine all together you will hit a performance issue at some point again.
OpenEdge Product management identified that for a perfect solution the whole has to be rewritten but this isn't on the product map and I guess it never will be as there is no real pressure by the users!
Seems to be other OE developers don't use it, uses Infragistics (still), as it was supported by Progress first or don't allow grouping/sorting/filtering or have workarounds using own assemblies created in C# or less data?
The final situation is, it can be used for larger data but not with all features in combination.
As we are used to say in German, "Friss oder stirb".
Rank 1
Veteran
[quote]Stefan said:
[...]
OpenEdge Product management identified that for a perfect solution [...]
The final situation is, it can be used for larger data but not with all features in combination.
As we are used to say in German, "Friss oder stirb".
[/quote]
Hello,
you've giving the answer to yourself, it can't be a perfect solution, if you're not able to use all features of the control.
It's just a workaround...
I think the GridView is the most essential control and it isn't working correctly in a good performance. (by using OpenEdge)
Regards
Rank 1
Hi Marc,
I agree but for me it looks like the current situation is the best we can get without a full rewrite.
I'm curious about the originator "Kashif" of this track, maybe he surrendered or found another secret solution?
"GridView is the most essential control" - then I don't know what all other OE developers are using ...
For me this discussion is over, I propose you to open your own ticket at Openedge and find more developers to increase the pressure.
Maybe an enhancement request to get a new OpenEdgeDataSource working out of the box and tested with Telerik, Infragistics and DevExpress. But if this will be ready ......
I never tested TelerikControls with C# but I expect the quality checks are much better in this environment.
From my understanding the main issue is on the OpenEdge side, not here. I think Telerik tried the best to get OpenEdge working.
And on the OpenEdge side they got a regression bug already caused by the enhancements - fixed in the latest SP.
So they will definitely not touch it anymore - 99.999%
Rank 1
Veteran
Hi Stefan,
we've opened a case in 2017...
I'm with you, the main issue is the BindingSource.
Do you know, is there a possibility to write a PN in this forum?
Regards
Rank 1
Don't think so, but you can/should initiate a discussion here:
https://community.progress.com/ -> openedge-development
Rank 1
Veteran
I want write a pn to you, to connect via xing or linkedin ;-)