View Single Post
Old 07-06-2007   #5 (permalink)
Marco Shaw


 
 

Re: Compare 2 files with 6,000 entries each

Kiron wrote:
> $csv = import-csv users.csv
> # if users list is not of unique users already
> # $csv | sort-object user -unique
> get-content users.txt | foreach-object {if($csv -contains $_) {$_}}
>
>


Wow! The old method took 1 hour 39 minutes, this way took 26 seconds.
My only problem is that the old way returned 86 matches, but this faster
way returned only 35.

Something is up...
My System SpecsSystem Spec