Hello,

I've read in some books that to minimize network traffic, one possibilitie is to store some of the tables that are not always updated BOTH in local machines and at the server.

But what wold be the best technique to update these tables ?

- every time the executable is run ?
- once a day ?
- every time the table is acessed ?
- should I create some flags in my system to update the tables after some changes ?

What would b the best way to do it ?

If a table is beig used, I think it would'nt be possible to make a simple copy using COPY TO

What if I ZAP the local table, and APPEND FROM the table from the server ?

Is it really worth ?
Will there be any lost of speed ?

Thanks in advance

Cesar