>So, if I were to need to retrieve a single record, and it sits on another machine, how would I do it?
>
>Joe
>
Actually, we are speaking now about internal Fox processing. I'm not expert here (it would be better to ask someone from MS Fox team). However, the basics is following: if Fox wants to get particular record it takes record offset (all Fox records are of the same length) go to the record and take it. I guess that it travels through the network as part of network packet (again I don't know much here).
Surely, a record doesn't sit on another machine. The idea is that any time a user changes a record then all local buffers should be refreshed (again internally) and this is exactly the place when network limitation can fire.
From practical side: I have LAN/WAN system with 10 million records, 1.5 GB and it still fast.
P.S. I have strong suspicion :) that I could say something wrong about Fox internal things and I would really appreciate someone else comments here.