Multisite performance and database table quantity

  • Resolved thecreator01

    (@thecreator01)


    6 months ago

    Hello, your plugin really caught my attention and I appreciate your work. Recently I was researching sharding methods for wordpress database and noticed this plugin for better performance.

    Is this plugin suitable for WordPress multisite? When a subsite is created in the network, 50 tables are created and when we use this plugin, the amount of tables will be doubled? Can I get better performance with this plugin?

    I’m really wondering how the performance and storage works as the number of tables increases.

Viewing 1 replies (of 1 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for the question. Yes, the plugin does in fact work with multisite. Here’s a writeup on how to use it when you have a lot of subsites.

    https://www.ads-software.com/support/topic/is-it-multisite-friendly/

    Each subsite in a multisite network has some of its own tables. (All subsites share the same wp_users. wp_usermeta, wp_sites, and wp_sitemeta tables, but otherwise have their own tables, for example wp_2_posts, wp_3_posts, wp_4_posts, etc. ) Adding high-performance keys doesn’t add tables to your database. Instead it adds keys to your existing tables. And, yes, if you have a lot of subsites you’ll have a lot of tables. But no extra tables from this plugin.

    I hope that addresses your question.

Viewing 1 replies (of 1 total)
  • The topic ‘Multisite performance and database table quantity’ is closed to new replies.