Re: Informix-Dynamic Server 7.2x over a expensive line

Reinhold Egenter wrote: > We think about a trigger based replication of the "config.data". But, > is there a way to tell the engine(s): > > (a) given a select-statement using only "config.data", execute this > statement locally on the branch office server (no network traffic > over the telephone line) As long as the table accessed by your statement is local, there will be no network traffic. > (b) given a select-statement using tables stored central, execute this > statement on the central server (using the "config.data" stored > central if involved) You can define local synonyms for remote tables, so your SQL doesn't even have to "know" where the table actually resides. So your database will have the same structure locally and remotely, but certain "tables" will just be synonyms that point to a remote table. Network traffic will of course occur when such a synonym is accessed. However, it depends on your WAN setup how fast a network connection is established and released on-demand. I have never tried such a setup over a WAN, so your mileage may vary. I don't quite understand what you mean by 'using the "config.data" stored central if involved'. If you are used some kind of replication mechanism (trigger based replication should be sufficient if updates are rare), the data should be identical on both sides for most practical purposes. Or is "split-second accuracy" a requirement? Hope this helps, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+