Subject | Re: [ib-support] Clustering |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-07-10T08:10:54Z |
Diko,
another question is why do you want clustering? If it is for speed reasons,
you should first take a look at what you do - how your database is
designed, what indexes you have, your queries etc. Sometimes you also want
to restrict your database to run on a single processor because of decreased
performance if having two or more (I'm not a database administrator so I do
not know exactly which circumstances - but it used to be all Windows
installations and some Linux I think).
Of course, clustering may be required if running complex mathematical
expressions or having a lot of concurrent users doing complicated stuff
(when that is the case, avoid Firebird and go Oracle or something), but
most of us manage well by tuning what we do to fit Firebird/Interbase.
Set
another question is why do you want clustering? If it is for speed reasons,
you should first take a look at what you do - how your database is
designed, what indexes you have, your queries etc. Sometimes you also want
to restrict your database to run on a single processor because of decreased
performance if having two or more (I'm not a database administrator so I do
not know exactly which circumstances - but it used to be all Windows
installations and some Linux I think).
Of course, clustering may be required if running complex mathematical
expressions or having a lot of concurrent users doing complicated stuff
(when that is the case, avoid Firebird and go Oracle or something), but
most of us manage well by tuning what we do to fit Firebird/Interbase.
Set