Hi,

depending on your tables record size alot of network traffic can be generated.

&& determine how much MB is send over the network
?RECSIZE('yourTable') * 26000 / 1024 / 1024

if the network is heavily used and your tables recordsize is for example 1024 (resulting into about 26 MB of traffic) and the network only transfers about 1 MB per second the 25 seconds of your testcase are comprehensible.

If you don't need all fields of the table you can speed up the whole process by just querying the fields you really need to save network traffic, every byte counts.

Would be nice if FoxPro could use some kind of compression when used over a network. From my experience WinZip can compress a DBF to about 20-30% of its original size, since the DBF format wastes much space on character fields by just filling them up with spaces.

Regards
Christian