Walter
>Can you do the same test again, but make the resulttest 10 times as large ?
>I'd be most interested to see the difference.
>
>I guess that the difference between VFP and C# would increase as the C# solution seeks sequential and the VFP sulution seeks in a B-tree.
Since adding more records to the employees table there are now many superiors with superiors and so on so the tests are a bit more involving than before:
Language Records Time (secs)
VFP 10,000 0.361
C# 10,000 0.600
VFP 100,000 8.392
C# 100,000 13.430
VFP 200,000 18.737
C# 200,000 29.092
Kev