VB.net Nested ‘For Each’ Loop Slow
Can someone suggest how I can improve the performance of my nested For Each loops? This logic accepts a string variable CSV style parameter and converts it into a data table. We are adding some calculated columns to update specific fields later on in the process. I’ve noticed just from running the application via Visual Studio (also on a VM, which may attribute to some of the lagging) that my logic for updating the TotalHours & PTOHours fields runs very slow whenever a large amount of data is parsed into this data table.