WordPress depends more on the efficiency of the code that queries the database, and the templates in the theme that display the pages. And external requests (off site) And large images. And more. The best way to find slowness is via the Developer tools in your browser (usually via F9). The Network tab will show … Read more
On your new hosting place, create a new/empty WP install. That will create a database. Remember the credentials. Then create a new database, and import the data you got from the old host. Remember the credentials; assign the user/pass to that database. Then go into the new install, inside the wp-config.php file, and change the … Read more
Your problem is in the size of your site. You have huge site and now it’s not enough to have only W3 Total Cache plugin for caching. During publishing post, WordPress performs a lot of database calls, it updates some information about posts in database. So I can suppose that the weakest spot is in … Read more
It may be that the WP database is a bit ‘cluttered’ with draft posts and other things. I’d recommend an optimizing plugin to optimize the WP database. But it also depends on your traffic. Maybe the amount of traffic indicates a need to upgrade your hosting plan from a shared server to the next level.
You have a few options. If you don’t want to disable any plugins, try to use the P3 Profiler plugin to identify the plugin or plugins that are slowing down your site. If you don’t want to run experiments on your live website, you should make a copy on a sub-domain (you can use the … Read more
Check the number of post revisions for that one 50K word article. While in Edit Page, go to Screen Options and be sure “Revisions” is ticked. If you have more than one revision, WP is querying the database for that one large post and all revisions, and that will account for some – possibly all … Read more
AWS is good, but a bit hard to understand if you’ve never set up a server. You should take a look at http://rackspace.com for their cloud server package. It’s about $25 USD/month for a decent server. They also have a control panel for load balancing setup. I’ve hosted a bunch of WP sites on my … Read more
You could use the WP-Cron functions to scheduled events. Note though that this is pseudo-cron- it requires someone (or a bot) visit your site for the events to execute. To fire events more reliably, search for scheduling cron jobs (linux) or scheduled tasks (win). Depending on your hosting, you may have access to simple tools … Read more
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
Well yes but compared to what? Any query on the DB is going to add server load and thus page load so your question is not very useful without context. The PHP code WP uses to order posts randomly is found in query.php: case ‘rand’: $orderby = ‘RAND()’; Which results in the output like: SELECT … Read more