Re: WordPress 3.0 new content types
BP would benefit from some table reduction.
Andy and I talked at WordCamp San Fran about how some components would benefit greatly from using the posts table, like Private Messages and Groups. Other components like XProfile would be more tricky and may not see any performance improvements, but would still be doable similar to the WP3.0 Menus.
So, it’s a likely direction, but don’t quote me yet.