Let's Party! provides any database with table partitioning capabilities (as long as it is accessed using JDBC).
Why table partitioning? Because: 1. If you put your partitions on different hard disks you will gain throughput 2. Scans of tables will require less time, because you will access less data -> a little table scan can be much faster than an access by index on a big table 3. You can put partitions you use less often on slower hard disks or on the network 4. (MySql) You can compress data on partitions you don't want to write to 5. You can put partitions on different clusters, for example using C-JDBC (beware: selecting from more than one partition from different clusters will not work because C-JDBC can't do unions between two clusters) 6. On future versions there will be the option to remove a column (part of an index) if this has low cardinality and replace it with different partitions Please have a look (http://letsparty.sourceforge.net/) and contact me using the forum (http://sourceforge.net/forum/forum.php?forum_id=382504) in case you need any help. Leonardo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
