Post caching to support site growth and multiple users at the same time

The Multi-DB seems to be a great option to provide site stability. See that there is a WP Super Cache plugin which would seem to add better scalability in ways. Do you guys ever think that you would support this plugin, and do you have any experience with WordPress caching