[wp-trac] [WordPress Trac] #37923: Introduce shared wp_blogmeta database table for multisite installation

[WordPress Trac]

#37923: Introduce shared wp_blogmeta database table for multisite installation
------------------------------------------------+--------------------------
 Reporter:  johnjamesjacoby                     |       Owner:
     Type:  feature request                     |      Status:  new
 Priority:  normal                              |   Milestone:  Awaiting
Component:  Networks and Sites                  |  Review
 Severity:  normal                              |     Version:
 Keywords:  2nd-opinion has-patch dev-feedback  |  Resolution:
                                                |     Focuses:  multisite
------------------------------------------------+--------------------------

Comment (by andy):

 > it would be nice to be able to query for sites using some kind of other
 arbitrary method

 There is no need to move the primary source of truth into a global table.
 What you need is secondary index that covers all of the data you are
 interested in and supports an acceptable level of consistency. You can
 build that using filters and any data store you like: mysql,
 elasticsearch, etc.

 There is prior art in multisite search via external indexes. Proponents of
 a core patch should explore the needs, solutions and problems already
 understood by those who have done it. Use cases might differ too much to
 make a unified solution viable.

 I have browsed 37923-phase1.diff and it looks like quality code but I'm
 not convinced any of this is better than adding or improving the API for
 plugins.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/37923#comment:24>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform