Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
The posted sample code processes in the same amount of time as it takes to merely read the files. . . I use this for files with multiple hundred millioin records. . .
If the ONLY result needed is the simple match/merge, you might want to consider using the sort (as mentioned earlier). If there is additional business processing needed, you many want to consider adding this to the match/merge code saving multiple passes of the file(s) - which is where the time would be wasted. . .
Deciding which is the proper way to implement is not "fixed" - sometime the utility is better, sometime the code is better.