John:

>>Interesting thread. I'm away for a bit but when I get back I'll arrange for a >>big site to test this performance theory with a few 100 machines belting the >>server. But IMHO it will be a fairly special app where the *tiny* overhead of >>parsing SQL makes a visible difference, especially if you have to layer VFP >>code on top to make it work.

Sounds like a great idea. Be sure to let us all know what you come up with.

>>With respect, do you not think your SCANS and checking for updates may leave >>you *worse* off in performance if not maintenance?

Not quite sure what your asking.

>>one field out of the 200 in the table

Is that one field out of 200 in a record or one record out of 200 in a table?

Charlie