I have an application where i need to hide rows in the UltraGrid based on certain values. These grids i am working with are very large (up to 400k rows). The performance has been awful, and I have isolated the problem to the following line:
r.Hidden = false;
This single line is taking on average about 1.6 seconds to execute. The ultragrid i did these timings on had just over 13,000 rows.
Is this kind of performance expected?
Hello bsdev,
That kind of performance isn't expected. From what you've provided, it seems you're iterating through the rows in the grid and checking them one at a time. You might be able to get better performance by setting a filter on the grid.
http://help.infragistics.com/NetAdvantage/WinForms/2012.1/CLR2.0/?page=WinGrid_Filtering.html
I don't think the row filter will work, as i am hiding rows based on how big the grid size is, not the underlying data values. I am researching other alternatives. Suggestions are welcome.
Hello,
What functionality are you looking to gain by hiding individual rows? I would like to understand what you are looking to accomplish so that I can see if there is an alternative approach that would work better.
Let me know if you have any questions with this matter.