WordPress.org

Ready to get started?Download WordPress

Ideas

Native function to delete post revisions

  1. GiancarloZer0
    Member

    It would be great if the self-installed WordPress had a function to delete post revisions and to optimize the blog database without plugins needed. It would works like plugins such as "Delete Revisions" and "Optimize Database after Deleting Revisions", but it would be a native WordPress function (perhaps in the Settings or in the Tools menu).

    I believe this native function would be very useful not only for common personal blogs but also for major WP-based commercial blogs and news sites.

    Posted: 2 years ago #
  2. damsko
    Member

    12345

    I support this fully. I was planning to start new topic on it but will make my request here:

    It should be standard option in WordPress to: disable, limit + cleanup/remove post revisions. This in my opinion really should be part of WordPress. It is essential to keep a WordPress site manageable and should not be dependent on plugins.

    I do a lot editing/updating to posts and found after a few weeks as newbie WordPress user that my MySQL database grew disproportional. I could not understand why only to find that main culprit are the post revisions. After cleaning them up with the help of the 'Better Delete Revision' (http://wordpress.org/extend/plugins/better-delete-revision/) plugin my database went from 30mb back to a workable about 1mb. Mind that my database was already at 30mb after a few weeks. Now months of "WordPress'ing" and consequent removing revisions later my MySQL database is about 3.3mb. I'm sure that my database would have become well over 100mb when i would not found what was happening.

    Managing post revisions should not be "plugin territory". It is to essential.

    Posted: 1 year ago #
  3. Ipstenu (Mika Epstein)
    Half-Elf Support Rogue & Mod

    You can also edit your WP-config to limit how many post revisions get made. I keep mine to 5, and my DB is quite small.

    Posted: 1 year ago #
  4. damsko
    Member

    12345

    Thanks for the tip, i already found that. After i became aware of the problem with the post revisions that was also a measure i found and that i took but somehow it is not working 100% for me, still some post revisions will be stored. I think every 10 posts that i now edit there will still be 1 or 2 post revisions stored.

    This is line i use in wp-config.php:

    define('WP_POST_REVISIONS', 0);

    I have several bigger 'index posts' that i edit regular. These posts with title indexes range in size from 20 to 100kb. So every time i made a edit to one of them my database grew 20 to 100kb. I now have 864 posts and with the help of 'Better Delete Revision' cleaned up 4899 revisions up till now. My MySQL database would have been huge with something that i do not use.

    For me it would make good sense to have a option in WordPress Settings under by example "Writing" to enable/disable Post Revisions and to clean-up/remove stored (redundant) revisions. Those two options would be most important in my vision. Limiting number of post revisions but keeping enabled the revisions could be extra option.

    I frankly was surprised that these features were not standard in WordPress and that i had to look for plugins/hacks to manage this. Best would in my vision also be that Post Revisions would be option that was disabled by default in WordPress distributions. Now all is set that it stores post revision, stores post revision, stores post revision, stores post revision, stores post revision, stores post revision, stores post revision, stores post revision, stores post revision, stores post revision, stores post revision, stores post revision, stores post revision, ...

    I hope that is understood what i mean.

    Posted: 1 year ago #
  5. Ipstenu (Mika Epstein)
    Half-Elf Support Rogue & Mod

    Heh. Yeah, the problem is no two people use WP in exactly the same way. I've found keeping the last 3 revisions saves my bacon. Some people really do want (and need) all of them. Keeping to decisions, not options, the majority would rather have those revisions than not.

    Posted: 1 year ago #
  6. damsko
    Member

    12345

    I understand that post revisions are useful for many otherwise it would not have been implemented in WordPress but for the not so technical me and others like me it is a big miss that WordPress does not come with a native option to turn the revisions of and to clean them up. A good 100% working option in WordPress settings would be a big plus is my believe. Post revisions as it is now is a water tap constantly running in case someone needs it without a native option to turn the tap shut. So my basement was starting to flood. But when native post revision management is not useful or possible idea and 100% dismissed then all still OK with me ;-)

    What line(s) do you use in wp-config? same or similar as mine?:

    define('WP_POST_REVISIONS', 0);

    Posted: 1 year ago #
  7. Ipstenu (Mika Epstein)
    Half-Elf Support Rogue & Mod

    That's the same line I use, only mine is set to 5, which is about all I need on a Multisite.

    Yes, being able to turn them off requires a wee bit of Techy know how, but you have to balance that it with the pain it is when we have to explain to NON technical people the ways to attempt to recover older posts. This? Easier, safer, and as you learn and become more technical, you learn to do these things.

    Not everything will be an option in WP, ever, we just don't roll that way. Some things (like Multisite) are intentionally a little harder, becuase you need to get familiar with some things before you attempt to do them long term. It's not a bad thing, it's just leveling up :)

    Posted: 1 year ago #
  8. damsko
    Member

    12345

    OK thanks for the attention and feedback.

    I will not have high hopes for seeing a future native WordPress posts revisions management option ;-) although i still think it would be very useful for more people then just me.

    Greetings!

    Posted: 1 year ago #
  9. damsko
    Member

    12345

    Mika or other mod, please edit the link to 'Better Delete Revision' plugin in second post of this thread.

    Somehow my old link does not link to the correct plugin and i can not edit the post :-(

    'Better Delete Revision' plugin can be found here:
    http://wordpress.org/extend/plugins/better-delete-revision/

    Not under the other link, i do not know that plugin so do not want to recommend it.

    TIA damsko

    Posted: 1 year ago #
  10. WayneM1
    Member

    I absolutely agree this should be a native feature.

    I also understand how the WP team rolls on this sort of thing and they might consider it bloat. However - I think most WP users will agree that a constantly growing, and for MOST users, useless, overly redundant backup scheme is an incredible bloat to their database. I also think making this native would be much more friendly to webhosts servers that have to store all this redundancy.

    My current "must have" plugin list continues to grow for each WP installation. This would surely be minimal code in the core, and only needs to offer a few options on an admin section.

    Please consider this request.
    Thanks! :-)

    Posted: 1 year ago #

RSS feed for this topic

Reply »

You must log in to post.