Caching with dynamic content

Looks like I solved this. Found this very good tutorial/extension for W3TC http://www.xoogu.com/dynamic-shortcodes-extension-for-w3-total-cache I have tried this out and it works wonderfully and the difference is nice. Got a much better score on Pingdom speedtest.

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