Re: Online Instance Question

In article <32FF376B.5864@singnet.com.sg>, pearlkoh <pearlkoh@singnet.com.sg> writes >Hi > Am kind of a novice to Informix and networking. > Some help on the following would be most appreciated. > Thanks. >Woody. > >------------------------ >If on a single host machine, I have a large database (A) which is >constantly being updated and other databases of similar size or >relatively smaller sized databases resident, which would be a better >Informix solution, given the following: > o Informix environment - Informix 5.03xxxxx > o Database A is not dependent on any other database. > o The application that owns database A is does not access any other > database. > o The applications that own the other databases, do need to access > database A. > >I guess the two possible Informix db solutions would be: > 1 Create a large online instance and lump all the databases in it. > or Proably my prefered solution. > 2 Create online instances such that databases that logically belong > together reside in their own online instances. Access to "external" > databases would then be made through I-STAR. >Given that I am running all the databases on one host, would choosing 1 >over 2, imply that I have lower network overheads? No but lower memory overheads and lower context switching overheads due to less processes. >Does accessing a "server" database residing on the same machine, require >requests to go out into the network or does loopback confine it within >the machine? Normally you would use shared memory but loopback is available if you prefer it. >Are there any speed advantages by choosing option 1? -- David Williams