|Subject||Re: [firebird-support] Single fdb or multiple fdb's|
On Thu, 11 Nov 2004 13:39:56 -0700, Ray Jenkins <reofax@...> wrote:
> Sorry hit reply to the other topic and forgot to change the subject
> I am starting to move all the in-house apps to Firbird. They have been
> running on Clipper and Paradox database systems.
> My question is this...
> How do I structure the new Database? Do I have one single fdb file and
> just throw all the tables in the same db, or do I split it out into
> some logical transaction based groupings? If I split it into multiple
> fdb files can they all reside in the same directory or should I
> seperate them into different subdirectories.
Can you give some points about applications and current databases.
But generally from my practice - I put all tables from all related in some
way systems in one Database. You get a lot of benefits with such
organization - JOINs in selects, FKs, simple administration.