----- Original Message -----

From: Martin

To: DesarrolloDelphi@...

Sent: Wednesday, August 03, 2005 9:45 AM

Subject: Re: [Delphi] Firebird

Esto mandaron al grupo de Firebird hace algun tiempo, no habla de registros pero si de el tamaño de la BD:

 

Ann - thanks for the great info in your reply.  You might be pleased to know
> that we have done extensive data load/access tests in the 15GB range for our
> data warehouse and Firebird has been considerably faster than Oracle 9i in
> almost all cases.  We can, however, close the gap with careful attention to
> data placement and fragmentation with Oracle.  The primary method of doing
> this is with tablespaces - a collection of related tables and indexes within
> an Oracle database that can be managed separately from the rest of the
> database.  When table data is partitioned among several tablespaces, the
> engine can do large table scans in parallel (large table scans are
> practically unavoidable with the ad hoc nature of data warehouse queries).
> You can also backup/restore at the tablespace level.  This is not a
> commercial for Oracle - DB2 and Informix have the same capabilities.  I just
> think that this ability to divide and conquer huge data sets (dozens of
> tables with hundreds of millions of rows) is a feature that most data
> warehouse admins feel a need for. Incremental backups would also go on this
> list.
>
> I love Interbase/Firebird's elegance and economy.  It is far simpler to
> install and manage than any commercial database and just seems to "respect"
> computer resources more.
>
> I have followed this group pretty closely and have not seen a reference to a
> Firebird database larger than 15GB (and that was my own).  Are there larger
> ones out there?
>
> Thanks again,
> Fred Pratt

----- Original Message -----

From: Efrain Yanez Recanatini

To: DesarrolloDelphi@...

Sent: Wednesday, August 03, 2005 10:09 AM

Subject: [Delphi] Firebird

Alguien a utilizado esta Base de Datos a Fondo....... 1Millon re registros o
mas.... Como se comporta?