Multi-DB versus W3 Total Cache Dilemma?

I read the post that discusses a little bit about how you might be able to combine these two but I'm rather reluctant, especially as my technical expertise is quite limited at this time.

What would be the best situation for me if I had to choose one or the other?

I plan on having around 400-500 blogs running with my buddypress site. Furthermore, I expect the community component of my site to be extremely active because of the nature of the type of website I'm developing. So a couple of questions come to mind... Does the Multi-DB plugin distribute information out only for blogs or does it also distribute things out relative to the buddypress community components? If it only distributes by blog, does that mean the entire community aspects run on a single DB? With all of these considerations in mind, would Multi-DB or a caching plugin like W3 Total Cache be the better way to go?

Is there a good alternative to W3 Total Cache that works extremely well with the Multi-DB plugin?

  • Aaron
    • CTO

    It's apples to oranges. They do completely different things so you can't really compare them. The problems multi-db is designed to solve is filling a db with too many tables when you get around a few thousand blogs.

    I still think you can run both though without much trouble.

  • David Payne
    • Site Builder, Child of Zeus

    Thanks for your response Aaron.

    Are new tables generated with the development of new groups and forum topics with the BP community component? And if so, are these dispersed across several DBs with Multi-DB? How large would a community need to get, without thinking about the number of blogs attached, before you might see a performance issue?

  • Aaron
    • CTO

    No, BP does not create new tables. And again multi-db does not increase performance unless you are using it to segment your dbs to additional physical servers. It merely keeps mysql from dying when you try to stuff too many tables into one db than your OS filesystem can handle.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.