Here's the excerpt I was refering to. It's from VFUG April 1999 Newsletter.


Queries against large tables creates a great deal of network traffic. For
example, if there was a Contacts table with 50,000 records and you issued
the statement:

SELECT LNAME, FNAME FROM CONTACTS WHERE ZIPCODE="32216"

and there are only 12 matching records, how many records do you think will
be transmitted from your LAN server to your PC? The answer is: 50,000.
Remember, all the processing on a VFP-only system is done by the client CPU,
so all of the records have to be transmitted in order for the client machine
to read and accept or reject them (I realize that Rushmore doesn't
necessarily send the entire record, but play along). Again, even though you
have a network server, that is not the same as a database server.

By using client/server architecture, the server does the vast majority of
the query processing. In the above example, the SQL server itself does the
work; only the two fields for the 12 matching records are sent over the
network to the client.

LMK what you think. Thanks
John