>Your code is really big, so just one thought. If you have table buffering (5), VFP will try to buffer whole tables, i.e. all table data should travel over the network and all table data should be compared during tableupdate(). It's a huge overhead if your tables are big enough. Normally, app should use Row buffering. If you have some batch process where you really need in table buffering, you could separate it into small exe and run it from server.


Thanks very much, Edward,

But, how can I seperate the program into pieces, and put some on servers?
I believe some jobs are better to be performed on the server, without tranferring the huge amount of data through
the network. However, I just don't know how.

Do you think it would help if I put the program on the server side, and execute it through a shortcut to it from the
client terminal? ( I am suspecting whether this would prevent the transferring of data from the server to the client
terminals. I am also wondering what would happen this way: execution of the program is performed on the server,
or on the RAM of the client terminals?)

Many Thanks!

With regards,
Ron.