>>Thank you for the reply. But, under VFP 7.0, the same command worked much faster on a table with 3 times the records. But soon I upgraded to 9.0, all kind of spped issues kicked in. I will try to use gigabyte hub with gigabyte nic cards.
>>
>
>I think I saw this mentioned elsewhere, but be sure that CPDBF() matches CPCurrent(). This is something that changed in VFP 9 (to fix a long-standing bug).
>
>Tamar
I know this must be true for Rushmore to "kick in", but it will hardly influence the query in question.