We are using VB.NET with System.Data.DataTable objects that contain large volumes of data. We are evaluating which approach is the fastest and most efficient for selecting rows in specific scenarios.
1. Single row
2. Multiple rows
3. Single row with simple condition
4. Single row with complex condition
5. Multiple rows with simple condition
6. Multiple rows with complex condition
Which method is best for each case? Rows.Find(), DataTable.Select(), Manual Loops (For Each), LINQ, DataView.RowFilter? Any other methods?
Any performance benchmarks or timing comparisons for these methods would be helpful.