Crazy amounts of queries are run in wp-admin/install.php?step=2

[Denis-de-Bernardy]

To reproduce, create a wp-content/install.php file, and add the following:

add_filter('query', function($query) {
	var_dump($query);
	return $query;
});

… then create a new site accordingly.

It's admittedly minor since, at the end of the day, it works. But surely there's a means to reduce duplication somewhat in there.

[SergeyBiryukov]

Confirmed 507 queries.

113 of them are from add_role() and WP_Role::add_cap() calls when adding initial roles:
tags/3.7.1/src/wp-admin/includes/schema.php#L585​

71 are from delete_option() when deleting unused options:
tags/3.7.1/src/wp-admin/includes/schema.php#L526​

The rest are creating tables, populating default options, user meta, etc.

[wonderboymusic]

the roles thing is ridiculous, I attacked that here:
​http://core.trac.wordpress.org/attachment/ticket/20152/20152.diff

[pento]

Not much traction going on here. Anyone is welcome to re-open it if they feel like tackling it.