Re: Multiple Databases

>From: uunet!columbiasd.win.net!jon (Jon P. Alder) >Subject: Multiple Databases >Date: Wed, 14 Apr 1993 02:56:14 GMT >X-Informix-List-Id: <news.3040> > >A basic question that I never had to worry about before 5.0..... > >We are facing the decision whether to combine two databases together >that share some common data into one large database with more that >1000 tables or to keep them separate. Our database is 5.0 OnLine. >Which, from performance, etc. point of view is the recommended >practice. If the two databases are part of the same OnLine system, then there is no need to combine them at all. Database A can contain the shared data table(s), and database B can contain synonyms which refer to the tables in database A. You could even mix'n'match so that both A and B contained some shared tables and both contained some synonyms, though I see no virtue in such an arrangement. There would be no need to have I-Star, and the performance impact should be minimal. If the two databases are on separate OnLine systems, then you will need to consider more carefully. You will need I-Star to talk between the systems (even if they are on the same machine), and you will need to consider the performance of the queries, bearing in mind that some of the queries will be done by remote access. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>