db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "apoc9009@yahoo.de" <apoc9...@yahoo.de>
Subject Re: Features: Tablepartitioning, Tablespaces and replication and Loadbalancing
Date Tue, 26 Apr 2005 20:20:52 GMT
Mike Matrigali wrote:

> table partitioning-
>       The question here is why do want to partition the table.  If it
>       just to spread I/O randomly across disks, I don't think it is a
>       very useful feature.  The same thing can easily accomplished on
>       most modern hardware/OS's at a lower level while presenting the
>       disk farm as one disk to the JVM/derby.

One simple but big Table (larger then 1 GByte of Data and expanding)
could be splitted into serveral smaller Units for faster Query processing.
 (ORACLE and IBM DB2 are able to partitioning Tables in this way, but
the Price is up to over  30.000 USD $)

>       Now if you are talking about key partitioning then that may be
>       useful, but only if accompanying work is done to partition
>       query execution in parallel against those partitions.  Below
>       I will describe one approach that I think is the easiest and most
>       maintainable first step towards this.


View raw message