Fastest way to fetch posts across a multisite

yup it is fast, it would be even better for you to use the WP Transients API to cache your query for a short period. Basically: if($saved = get_site_transient(‘SOME_SORT_OF_ID’)){ echo $saved; } else { ob_start(); switch_to_blog(x); // x being the blog id your want to switch to // Do your quering and echoing here restore_current_blog(); … Read more

Efficient way to fetch all archived WPMS blogs

You can go directly to the database via $wpdb. <?php $wpdb->get_results( “SELECT * FROM $wpdb->blogs WHERE archived = 1” ); Or wrapped up in a function: <?php function wpse34731_get_archived_blogs() { global $wpdb; if( empty( $wpdb ) ) return; $blogs = $wpdb->get_results( “SELECT * FROM $wpdb->blogs WHERE archived = 1” ); return $blogs; }

Automatic creation of mutisite blog outside of the admin

You could use this WordPress function within your form code: http://codex.wordpress.org/Function_Reference/wpmu_create_blog With this and a custom template you can allow any user to create a blog for himself (For some sample code you could see how wordpress itself does it on wp-signup.php on WordPress root dir)

How does WP decide how to evaluate database integrity

I’ve finally found the answer. Yes WP was ‘triggered’ to think it was evaluating a WordPress and not a WordPress-MU table structure. This was caused by the following lines: define(‘WP_ALLOW_MULTISITE’, true); define( ‘MULTISITE’, true ); in the wp-config.php that should NOT be there in a WordPress-MU 2.9.2 installation (but that some former developer had tossed … Read more