This is a migrated thread and some comments may be shown as answers.

Multicolumncombobox compositefilter too slow

5 Answers 389 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Ignacio
Top achievements
Rank 1
Ignacio asked on 25 Oct 2018, 09:03 AM

Hi all,

I've implemented a radgridview in my project, and I need one column to search, in this case, a barcode but I have two ways for search it. The barcode and a small code which are related between. So I've implemented a multicolumncombobox and a composite filter to do this. It works, but I have a problem in some cases. When the combobox has a lot of data, the filter which has the property autocompletemode as suggestappend, it is working too slow. For example, I press one key  it takes too long time to appear in the column, it appears to be freeze.

Do you know how to improve this? Or there is another control to make this purpose?

Thanks in advance.

Regards,

5 Answers, 1 is accepted

Sort by
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 25 Oct 2018, 10:30 AM
Hello, Ignacio, 

We already have a similar issue logged in our feedback portal. You can track its progress, subscribe for status changes and add your comments on the following link - feedback item.

Currently, the possible solution that i can suggest is to use custom filtering instead of CompositeFilterDescriptor. A sample approach is demonstrated in the referred feedback item.

I hope this information helps. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Ignacio
Top achievements
Rank 1
answered on 26 Oct 2018, 07:55 AM

Thanks for the reply, I've tried to implement the custom filter on my grid multicolumncombobox but the process is not working as expected. Event is not firing when I write in the cell, it is firing when i click in the cell, it is very strange because I followed the same steps you posted in this link (https://feedback.telerik.com/Project/154/Feedback/Details/176209-fix-radmulticolumncombobox-filtering-performance-and-cursor-lagging)

Thanks anyway! 

0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 26 Oct 2018, 11:28 AM
Hello, Ignacio, 

I would recommend you to have a look at the following help article demonstrating how the custom filtering works for RadGridView: https://docs.telerik.com/devtools/winforms/gridview/filtering/custom-filtering

You can also refer to our Demo application >> GridView >> Filtering >> Custom Filtering example.
 
If you are still experiencing any further difficulties, feel free to submit a support ticket where you can provide a sample project demonstarting the undesired behavior. Thus, our support staff will gladly assist you.

I hope this information helps. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Ignacio
Top achievements
Rank 1
answered on 31 Oct 2018, 02:58 PM
Finally I could implement the custom filter in my radmulticolumncombobox, but the event customfilter is being called for each line for the grid inside the radmulticolumncombobox. So, when I have 500000 rows to filter, the program is frozen for a long time, well, it doesn't work again.
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 01 Nov 2018, 11:10 AM
Hello, Ignacio, 

Indeed, the CustomFiltering event is fired for each row in the popup grid in order to determine whether the row matches the filter criteria or not. However, to be honest, 500 000 rows is a huge number and it is normal to affect the performance in RadGridView. For such case, it is suitable to use a 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 refer to the online documentation for getting started experience and how to filter the loaded data on demand: 
https://docs.telerik.com/devtools/winforms/virtualgrid/overview
https://docs.telerik.com/devtools/winforms/virtualgrid/filtering/filtering

You can host the RadVirtualGrid in a RadPopupEditor and thus simulate RadMultiColumnComboBox:
https://docs.telerik.com/devtools/winforms/editors/popupeditor/popupeditor
https://docs.telerik.com/devtools/winforms/editors/popupeditor/getting-started

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
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
GridView
Asked by
Ignacio
Top achievements
Rank 1
Answers by
Dess | Tech Support Engineer, Principal
Telerik team
Ignacio
Top achievements
Rank 1
Share this question
or