Hi Richard,
To get a better performance when hidding/showing the large number of rows, you need to use the grid virtually. There is a sample in this forumn thread that you can check in this regard. Below is the address if it.
http://www.syncfusion.com/support/forums/message.aspx?&MessageID=6597You should also take a look at the VirtTreeGrid sample, as this uses the sample technique to dynamically show/hide blocks of rows. The idea is to have an array list of visible rowindexes, and then use this array list virtually to display the visible rows.The virtual technique works better in this case.
Another way to do this would be to have an extra column in your DataTable say ‘HideStatus’ to keep track of the hidden rows. You can initially set the value to be false and apply filter from Grid to show the records that satisfy the false criteria. So whenever you need to hide a row, you just need to set the bool value of that Row field to true. This will be very faster.
Please refer this sample for the implementation:
GGCHideRowsBest regards,
Haneef