>Kev,
>
>>I would be interested if you could give me the time comparisons for each method and what the criteria was and how many records/fields were involved.<
>
>I did that, more or less, in one of the posts already. Here's a quote from that post:
>
>>Again, it still looks like the iterative and the select methods produce roughly the same results ... no matter *how* many rows you're searching through. Which, I find pretty strange ... but I'm guessing that probably the .Select() does the same thing under the covers ... just iterates.
>
>But, the DataView ... wow!!! Don't use it unless you have to!! (At least not for this type of scenario, searching a Lookup table) ...with only 1000 rows in my Lookup table, the DataView was 50 times slower. With 10,000 rows, it was 400 times slower!!!<
>
>Basically, all I did was have a lookup table, first with < 100 rows in it, then with around 1,000 rows, then with about 10,000 rows. I had another table, containing about 60 rows. I went through each row in the 60-row table, and did a search in the lookup table for a column value from each row. I also tried to have an equal distribution of values in the 60-row table that I was looking up ... some at the beginning, middle and end of the lookup table.

Sorry, I must have skimmed a bit too much <g>

That's exactly what I've found, the Select() and iteration took around 0.04 seconds and the DV took around 0.09, and the tests were consistent with the amount of rows used too.

This thread has branched off into a .Net performance thing now, like you've said, I'll post any other findings in the .Net one.

I'm also still doing some comparisons using Walter's suggestions, although it's comparing Fox's local DE with ADO.Net, and to be honest, there IS no comparison.