[wp-trac] [WordPress Trac] #24922: Please do not hardcode network upgrade to 5 sites at a time.

[WordPress Trac]

#24922: Please do not hardcode network upgrade to 5 sites at a time.
---------------------------+-----------------------------
 Reporter:  _ck_           |      Owner:
     Type:  enhancement    |     Status:  new
 Priority:  normal         |  Milestone:  Awaiting Review
Component:  Network Admin  |    Version:  3.6
 Severity:  minor          |   Keywords:
---------------------------+-----------------------------
 Upgrading hundreds of thousands of sites via network upgrade is a process
 of insanity with browser based 5-at-a-time limit.

 Please put a filter on it and/or allow it to be set via get_options.

 Hardcoded "5" can be found in `/wp-admin/network/upgrade.php`

 CLI tool for upgrading would be even better - I guess I can extract the
 code from that script to make it CLI based at high speed.

 Also, why does the query for the upgrade use

 `$wpdb->get_results("SELECT * FROM`   (note the select wildcard)

 when only  `$details['blog_id']` is used in the script afterwards?

 You could fetch thousands of integers at a time if you didn't use a
 wildcard to wastefully grab and return all columns.

 Use instead

 `$wpdb->get_col("SELECT blog_id FROM`

--
Ticket URL: <http://core.trac.wordpress.org/ticket/24922>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software