>Are you sure? And how does VFP know which part of the file to transfer?

In George Goley's book "Creating FoxPro Applications", he cites the following example:

Sample table: 449,996 records occupying over 40Mb of disk space on a LAN.

He performed the following:

SET EXCLUSIVE OFF
SELECT li_ivno, li_invntry FROM bkitms WHERE ;
li_ivno="199100000001" OR ;
li_ivno="199100100000"

The query completed in 1.5 seconds, returning the first two and the last five records from the bkitms table.

The LAN obviously couldn't transfer 40Mb in that timescale.

He did a similar demo with 5 users simultaneously querying a 680,000 70Mb+ table. Each query completed within 2 seconds, with subsequent queries completing in less than a second.

This was in FoxPro 2.5, although the principle is the same.

I have no idea how FoxPro (any version) does this, but I've demonstrated it with my own data.