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

[WordPress Trac]

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

Comment (by mnelson4):

 So to clarify, the main problem right now is that if you want to query for
 all sites' names, you would need to do an SQL join to ALL site option
 tables (or loop through them all). Yeah, that makes it pretty well
 impossible doesn't it (especially once you have a network with over 100
 sites or so).

 So this site_meta table would only be used for options you know you want
 to query, right?

 Admittedly, it would be a little confusing having two places for this
 site-specific data (is it in the options table or in the site meta table?
 Depends on how much we want to do a multi-site query involving it). This
 could probably be alleviated by having `get_site_option` magically check
 in the blog meta table for entries it knows are stored there and not in
 the options table. Eh?

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