WP Multisite: Use one central table instead of current status

  1. Feriman


    Currently WordPress using one wp_options table per site. It is using a few KB. It is fine if we have only few blogs.

    But if we have a lot blogs ( 10000+ ), these are mostly same tables.

    The idea is if we using one (central) table for each site, then:

    - Using so much less database size ---> faster running, less backup size
    - We have to modify only one (central) wp_options table for set default settings for every blogs.

    How much less DB size using with this solution?

    A lot. If we have 10000 blogs then saving ~1GB space in database ( count with 100KB table size ).

    Upvote this idea, if you agree with this solution.

    Thank you!

    Posted: 3 weeks ago #
  2. Ipstenu (Mika Epstein)
    Lead Plugin Wrangler

    They all have separate content. Which is the point of Multisite. Separate the content.

    And that's why the settings are different on each blog. They're supposed to be separate sites. There are plugins that can keep things like default settings in sync, but maybe you should look into running one site and having custom post types instead of separate blogs?

    Posted: 3 weeks ago #
  3. johnawesome


    I totally agree with this idea.

    I think the publisher forgot to insert this below important thing about the idea:

    If someone changed the settings of his blog, then WordPress will create one custom wp_options table (ex. wp_BLOGID_options) what will use just this mentioned blog. All others (which didn't change anything in the settings) have this central wp_options table.

    So why using a lot of same datas anywhere ( in this idea: database ) if we can use these from one certal place? This is possible with softlinks (like in Linux systems).

    Posted: 3 weeks ago #
  4. Ipstenu (Mika Epstein)
    Lead Plugin Wrangler

    There were (and probably still are) plugins to do that, to manage settings, but again, your'e going against the intent of Multisite. This is fine, but you do need to keep in mind what you're up against when you use a tool in a way it wasn't intended :)

    Posted: 3 weeks ago #
  5. Siam

    I liked this idea, and maybe like WordPress.com services.
    Hope some Dev to release the code.
    Thank you.

    Posted: 3 weeks ago #
  6. Ipstenu (Mika Epstein)
    Lead Plugin Wrangler

    WordPress.com is using Multisite, actually.

    Posted: 3 weeks ago #

RSS feed for this topic


You must log in to post.

  • Rating

    3 Votes
  • Status

    This idea is under consideration