I don't know either... :) Probably the CDX was transported sometime before the seek.

As a second thought: a search into an ordered file does not require one to read all the file. I don't read all the dictionary when I look for an word. :)

Vlad

>I was under the wrong impression about this stuff...so I did a test...I did a SEEK on a file...I got the record back faster than I could copy (DOS) the CDX to my hard drive...I did this when I was the only person around, so there was next to no network traffic...I don't know how VFP does it, but I ain't complaining :).
>
>Take care,
>Joe
>
>>What about the indexes used in these examples?
>>
>>Vlad
>>
>>>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.