Subject Re: [Firebird-Architect] Re: Table partitioning
Author Jacqui Caren
Daniel Rail wrote:
> I'm with Jim here. The feature is not required. If you want
> performance and having the database across multiple hard-drives, it is
> better to go with a RAID system using striping.

A few years ago we did some work with an Oracle installation.

The partitioned table allowed up to 10,000 inserts per second
whereas a 'standard' oracle table was limited to a mere 2,000 IPS
(for our specific application data).

In short, this feature provided significant advantages beyond
working around some very old disk problems.

Of course, FB is not Oracle. It does not have Ora's overheads
to surmount so it would not provide any of the advantages
that it gives Oracle.

Jacqui