> 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 _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
