hi,
I think in dbf exclusive or shared mode is configured by programmer, only by programmer.
do you know how "Share" Mode work with SMB
DBF are NOT made for Network it must "Share" a "File-Based" System using SMB
SMB will "slow down" when 2nd User open same DBF -> "Opportunistic Locking"
so i ask for at least 2 x PC and "Server" to simulate Access Time.
that is the Benefit of a Client / Server System where you do not have "direct Access" to Data.
---
as i can say DBF is faster when work "Record-based" e.g. when SEEK()
SQL will be much faster when have a "big Filter" where you can´t build a Index / SCOPE for DBF to "limit" it.