WordPress.org

Ideas

WP Multisite: Use one central table instead of current status

  1. Feriman
    Member

    12345

    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: 2 months 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: 2 months ago #
  3. johnawesome
    Member

    12345

    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: 2 months 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: 2 months ago #
  5. I liked this idea, and maybe like WordPress.com services.
    Hope some Dev to release the code.
    Thank you.

    Posted: 2 months ago #
  6. Ipstenu (Mika Epstein)
    Lead Plugin Wrangler

    WordPress.com is using Multisite, actually.

    Posted: 2 months ago #
  7. Feriman
    Member

    12345

    The main benefit would be the easier setup the default settings.

    Posted: 1 week ago #
  8. Ipstenu (Mika Epstein)
    Lead Plugin Wrangler

    That's all hookable. The only think that would be easier is keeping multiple sites in sync with the same settings.

    Posted: 1 week ago #

RSS feed for this topic

Reply

You must log in to post.

  • Rating

    12345
    3 Votes
  • Status

    This idea is under consideration