Hi,

Recently I put the following question in the forum: Is VFP a true Client-Server ?
My purpose now is to share with you the results of my searches and solutions.
Because VFP is not a server based database the traffic between a server and a client workstation never stops during the time the query is running.
Following one of your suggestions I find that the implementation of a DCOM (Not COM) object in the server is the better solution to eliminate the traffic between the Client and Server during the resolution of the query in the serve side.
Mainly, there is a program running in the server side who will execute a string passed by the client and creates a file in the server. This file is downloaded in a second operation (using a select, copy, or ftp commands).
The delicate part is to register the DCOM in the server which needs a Windows NT OS.
The DCOM in the server as a "mirror" DCOM in the client side.
I tested the performance of all this stock in an environment simulating a server connected to a client throughout T1 lines. The result was amazing. The sniffer didn't detect any traffic related to our query, and the time to obtain the results decrease from 10 (ten) minutes to…. 30 (thirty) seconds.

I'm about to write a detailed procedure to document the operation. Once ready, if someone will be interested, I will share with you.


And again, thanks folks to put me in the right track…