Subject Re: [Firebird-Architect] Re: Table partitioning
Author Daniel Rail
Hello johnson_dave2003,

Monday, December 6, 2004, 7:44:51 PM, you wrote:

> This is indeed the practice in performance tuning other DBMS's (DB2
> and Oracle specifically).

Most likely those RDBMS systems introduced these performance tuning
techniques when RAID(or anything similar) didn't exist, and that the
hard-drives were under 500MB and probably under 5400RPM. And, that
those techniques were only work-arounds for those days, and because
they were implemented, it was probably hard to remove them when they
could've been removed.

> One physical device for one type of I/O
> that is anticipated to be in parallel. There is no advantage to
> splitting one table across multiple devices. However, there is an
> advantage to separating table from index, and both of these from logs.

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.

Best regards,
Daniel Rail
Senior Software Developer
ACCRA Group Inc. (
ACCRA Med Software Inc. (