Speedup WordPress Tip#4
Tip#4: Housekeeping is important!
Some common tips you see all over the internet is to remove deactivated plugins. DELETE! DELETE! DELETE! If you deactivated it once, don’t hang on to it. You didn’t like it once, you are not likely to want it the next day either! WordPress goes through all plugins, active or not, every page load. That’s alot of wasted cpu cycles per person accessing your site, and it adds up. What may not seem like a big deal late at night maybe a different story during peak times. The short of the point is to delete unused plugins.
Database maintenance: You’ll notice a common theme here, and that is the database speed is a major factor in determining how fast your page will load on the screen. There’s actually a few things you can do to help.
- Turn off Post Revisions: I rarely use them, and when I go back to edit an old post it always says there is a newer version of the post, that’s because it auto-saved a copy of the post, after I saved it. Ok, this is just plain wasteful, turn that off, and to do so, simply add this to your wp-config.php:define(‘AUTOSAVE_INTERVAL’, 500 ); // seconds
define(‘wp_1_POST_REVISIONS’, false );
- SQL Command to delete all the revisions in the WordPress Database DELETE FROM wp_1_posts WHERE post_type = “revision”; (Run that line in MySql Manager)
- Keep all your plugins up to date. That should be simple enough, the authors release updates to fix problems, and only occasionally create new ones. (You are backing up right?)
- Keep WORDPRESS up to date, ok this may be more important than the plugins, being out of date on wordpress can be like getting caught with your pants down. WordPress updates make wordpress faster, fix security issues, and sometimes break stuff. (Remember to Backup, floss, yada yada yada…, you get my point right?)
- Optimizing your MySQL Database. To do it you need to go to phpMyAdmin and select your database. Then towards the bottom, click check all to select all tables and then towards the center of the screen, there is a drop down menu, click optimize tables there, and then repair. (Backups are really important..)
If you remember to do these once a month, like a check list, (You can always bookmark this page and refer back) your WordPress site will be in top notch shape!