I just had a quick look at the federated table type. A few caveats: 1) Transactions are not supported
2) The remote table (there can be only one, it seems... someone correct me if this is wrong) is accessed via MySQL Client API, therefore speed issues galore 3) There is a 1:1 mapping between the local federated table, and the remote table (which may be of any type) so you cannot "aggregate" multiple remote tables onto a single local table. Thus, data partitioning is STILL the responsibility of the application. With all of these limitations, I have trouble seeing the benefit of this feature. _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
