Informix-Dynamic Server 7.2x over a expensive line 
Author Message
 Informix-Dynamic Server 7.2x over a expensive line

Hi Informix-Guru's (at least I think we need one),

we have to access a database (I-DS 7.2x, UNIX) from several branch
offices using expensive telephone lines (ISDN). Some of the data is
"config.data" that is changed seldom but accessed very often. We try to
cache this data in the branch offices using another Informix engine
(I-DS Workgr.Edition 7.2x, UNIX).

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)

(b) given a select-statement using tables stored central, execute this
    statement on the central server (using the "config.data" stored
    central if involved)

Any ideas would be appreciated. Please send suggestions to

Regards,

Reinhold Egenter.



Wed, 18 Jun 1902 08:00:00 GMT
 Informix-Dynamic Server 7.2x over a expensive line

Quote:

> 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.

Quote:
> (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
--
+--------------------------+------------------------------------------+

| EDV-Gruppe Anaesthesie   | Tel     : +49-89-7095-3413               |
| Klinikum Grosshadern     | FAX     : +49-89-7095-8886               |
| 81366 Munich, Germany    | GSM     : +49-172-8933578                |
+--------------------------+------------------------------------------+



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3

2. PRESS INFORMIX TO PROVIDE INFORMIX-ONLINE DYNAMIC SERVER 7.1 FOR SCO OPENSERVER RELEASE 5

3. Replication between Informix Dynamic Server 7.31 and SQL Server 7

4. SQL Server 7 connected to Informix Dynamic Server using OLE-DB

5. Replication between Informix Dynamic Server 7.31 and SQL Server 7

6. SQL Server 7 connected to Informix Dynamic Server using OLE-DB

7. Informix Dynamic Server.2000 (version 9.2) on a Windows 2000 Server

8. Informix Dynamic Server V7.3 on SCO Open Server V5.04 installation problem

9. HELP - Informix Dynamic Server (Iconnect) and MS Terminal Server

10. where can I download Informix Connect 7.2x ???

11. Informix 7.2x GLS

12. Informix SE 7.2x Performance Problems - Limitations?


 
Powered by phpBB® Forum Software