Hi I have a datatable of 20K rows and I have to loop through each row’s Record ID column and check if this Record ID exists in another datatable using Datatable.Select.
If it does not exists, then I would add that row into the datatable being filtered.
However this process is now taking over 1 hour to complete.
Is there anyway to hasten it?