Multicolumncombobox compositefilter too slow

6 posts, 0 answers
  1. Ignacio
    Ignacio avatar
    3 posts
    Member since:
    Oct 2018

    Posted 25 Oct 2018 Link to this post

    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,

  2. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3759 posts

    Posted 25 Oct 2018 Link to this post

    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.
  3. Ignacio
    Ignacio avatar
    3 posts
    Member since:
    Oct 2018

    Posted 26 Oct 2018 in reply to Dess | Tech Support Engineer, Sr. Link to this post

    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! 

  4. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3759 posts

    Posted 26 Oct 2018 Link to this post

    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.
  5. Ignacio
    Ignacio avatar
    3 posts
    Member since:
    Oct 2018

    Posted 31 Oct 2018 in reply to Dess | Tech Support Engineer, Sr. Link to this post

    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.
  6. Dess | Tech Support Engineer, Sr.
    Admin
    Dess | Tech Support Engineer, Sr.  avatar
    3759 posts

    Posted 01 Nov 2018 Link to this post

    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.
Back to Top