Performance wise what is the best way to compare 2 DataTables with approximate 1000 records?
I have looked into LINQ and DataRelation and googled a lot and was not able to reach a optimum solution for a datatable with only about 1000 records
Asked
Active
Viewed 645 times
0
Raidri
- 17,258
- 9
- 62
- 65
Arun Bertil
- 4,598
- 4
- 33
- 59
-
What type of comparison are you trying to do? – Dan Drews Nov 18 '13 at 05:03
-
compare and get the result in another datatable – Arun Bertil Nov 18 '13 at 05:04
-
1The best way? The optimum way? Since there are only 1000 records, performance is not an issue. Do it as simple and straitforward as possible. – Steve Wellens Nov 18 '13 at 05:08
1 Answers
2
public static DataTable CompareTwoDataTable(DataTable dt1, DataTable dt2)
{
dt1.Merge(dt2);
DataTable d3 = dt2.GetChanges();
return d3;
}
I do prefer the above datatable inbuilt methods to achieve such a functionality as LINQ is doing an internal looping over the datatable rows for the process. As rows and columns goes up this may end up with perfomance leaks.
Praveen Prasannan
- 7,093
- 10
- 50
- 70