-
Wordpress wp_posts SQL Hack
July 17th, 2009
Speeding up Wordpress by deleting all revisions.
The Wordpress db keeps all revisions. If you have a large database (say 100,000 records) you can speed it up by deleting the revisions. The code for that is:
DELETE FROM wp_posts WHERE post_type = “revision”;Your actual wp_posts table will have a name like wp_xd7tjs_posts. This is to improve Wordpress security. If your wp_posts is named wp_xd7tjs_posts then the code is:
DELETE FROM wp_xd7tjs_posts WHERE post_type = “revision”; -
wordpress.org
July 17th, 2009
wordpress.org great software for developing most simple web sites. Wordpress’ strength lies in its simplicity. Many CMS are often over engineered. Wordpress gets the job done for most web sites and is a great way to learn XHTML and Php.
Tag: Wordpress