[DUG] Why InterBase

[Phil Scadden]

> Interbase seems ok - haven't used it that much so can't comment on
> performance. It seems to be a good small footprint db. My question is how
> does it scale? How does it handle large databases with millions of records? 
> How good are the tools provided for DBA's?

"How well does it scale" is a difficult question. I have heard that IB/FB doesnt
do well with multi-table joins once no. of tables gets above 3. I havent tested.
On single table is scales extremely well once got rid of the 2GB file
size limit. One application that did for a client (hi Alan!) needed fast indexed
access to tables with many millions of records. FB could outgun our
oracle server even on inferior hardware!  Tools for DBA? What DBA?

----------------------------------------------------------
Phil Scadden, Institute of Geological and Nuclear Sciences
764 Cumberland St, Private Bag 1930, Dunedin, New Zealand
Ph +64 3 4799663, fax +64 3 477 5232