>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