Generate aggregated feed from member blogs

Here’s one option we use for a high volume global RSS feed. It’s worked out really well for us and has lower load times than trying to do some runtime combination. http://premium.wpmudev.org/project/post-indexer/ http://premium.wpmudev.org/project/recent-global-posts-feed/

How to optimize ‘select found_rows()’ query? Several ‘high load average’ alerts daily

This should not break pagination: add_filter(‘pre_get_posts’, ‘optimized_get_posts’, 100); function optimized_get_posts() { global $wp_query, $wpdb; $wp_query->query_vars[‘no_found_rows’] = 1; $wp_query->found_posts = $wpdb->get_var( “SELECT COUNT(*) FROM wp_posts WHERE 1=1 AND wp_posts.post_type=”post” AND (wp_posts.post_status=”publish” OR wp_posts.post_status=”private”)” ); $wp_query->found_posts = apply_filters_ref_array( ‘found_posts’, array( $wp_query->found_posts, &$wp_query ) ); if($wp_query->query_vars[‘posts_per_page’] <= 0) { $wp_query->max_num_pages = 0; } else { $wp_query->max_num_pages = ceil($wp_query->found_posts … Read more

User cannot authenticate after signup when object cache enabled

This is now solved The solution was this in the activation script: $blog_real_id = $wpdb->get_var(“select blog_id from wp_bp_user_blogs where user_id = “.$user_id.” limit 1″); wp_cache_key_delete(“1:users:”.$user_id); wp_cache_key_delete($blog_real_id.”:users:”.$user_id); This clears the cached user info for blog id 1 and the signed up blog ud. For some reason the password hash that is in memcache is wrong. Clearing … Read more

Caching for logged in user and Ajax update

There are plugins that can help you with this, but they aren’t foolproof. My suggestion is W3 Total Cache, you should be able to exclude necessary files from the cache from there. Your best solution, however is to do caching on the serverside level as you will see better performance that way.

Session alternative for plugins (due to caching)

A similar question popped at [wp-hackers] and apparently Eric Mann‘s plugin, WP Session Manager, is the way to go. I haven’t analyzed the plugin’s code, so cannot tell about its inner workings. Pippin Williamson embeds WPSM in his Easy Digital Downloads plugin. Given Pippin’s review and Eric being such a pro-old-timer-wp-ninja, I wouldn’t look no … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)