I have seen this as an issue and have not seen an answer that fits my need. I am using UltraGridFilterUIProvider and when the user filters on some of the columns it takes a long time to sort.
How can I optimize the filter to speed up the results. The user is filtering more than 30k rows. Thank you
Hello Thomas,
Thank you for contacting infragistics support.
Regarding the UltraGridFilterUIProvider have couple of thing to share with you.
1) I am not sure sure which version of control you are using but with the latest version 17.2 our developers did work on UltraGridFilterUIProvider in order to improve the performance.2) Though 30k rows is much data to process and that is why it’s taking more time.
I would recommend you to follow these post a senior developer provided more information for improving performance of UltraGridFilterUIProvider :
https://www.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/54994/ultragridfilteruiprovider-slow-performance In
this post I provided more information: https://www.infragistics.com/community/forums/f/ignite-ui-for-javascript/111781/filtering-in-
ultragrid-works-slowly To improve the overall performance of the Grid you can also follow this
post: https://www.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/15306/wingrid-performance-guide
Please let me know if you need further assistance.
Thank you very much Divya.