Subject | Re: [Firebird-Architect] Re: Table partitioning |
---|---|
Author | Jacqui Caren |
Post date | 2004-12-07T16:45:02Z |
Daniel Rail wrote:
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
> I'm with Jim here. The feature is not required. If you wantA few years ago we did some work with an Oracle installation.
> performance and having the database across multiple hard-drives, it is
> better to go with a RAID system using striping.
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