>Isn't it true that when a workstation looks at data in a FoxPro table on a VFP form, that the entire table comes down to the workstation physically, perhaps as a temp file that is recognized as the table? And, isn't it true that this causes the LAN's bandwidth to be high if the tables are large?
Not necessarily. IIRC most of what comes down the line is index data that VFP uses to determine where real data is (depending on the operation).
It is true that this can use a lot of bandwidth on large tables, large result sets, or with complex queries.
SQL Server and other server based databases can be much more efficient (unless they are pulling large result sets - then they are about equal).
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________