Posted 5 years ago #
Hi!
I don't like the "Post Revision"-Feature at all because it creates a alot of useless database-entries.. Can anyone please tell me how to turn it off? I've tried to comment out some related functions but since my latest SVN-update on 12th May WordPress starts creating revisions again..
Just an idea: Would be great to turn that feature off in the Options/Write-Settings...
Posted 5 years ago #
At least I figured out how to prevent the automatic ajax-revisioning. In wp-ajax.php is the following code:
if ( $do_autosave ) {
// Drafts are just overwritten by autosave
if ( 'draft' == $post->post_status ) {
$id = edit_post();
} else { // Non drafts are not overwritten.
By commenting out the relevant lines it's possible to have some neat autosave while editing existing posts without creating revisions all the time (ouch, they really suck...)
To avoid revision-saving on clicking the "save"-button it is necessary to comment out the line //add_action( 'pre_post_update', 'wp_save_revision' ); in default-functions.php
Are there any more elegant ways to achieve this..?
Posted 5 years ago #
The specific files are "admin-ajax.php" in wp-admin and "default-filters.php" in wp-includes. Sorry for the mistake.. but I'm talking to myself anyway ;)
Posted 5 years ago #
In my little opinion, there should be an option in general or writing settings to enable/disable the post revision feature
Strongly agree. I can see its use for multiple authors but for me, it simply generates annoying unwanted database entries.
I can't even see yet how to delete unwanted revisions.
Posted 4 years ago #
...
Why would you ever want to delete a revision? That makes little sense to me. But then, I don't understand wanting it turned off either. If you don't want to use it, then don't.
I bet you're the kind of person who actually manually goes through and deletes old email too, right? You really have to get over this "it takes up space" thing. Space is cheap and virtually unlimited. :)
But... I think define('WP_POST_REVISIONS', false); in wp-config will disable them.
Posted 4 years ago #
But... I think define('WP_POST_REVISIONS', false); in wp-config will disable them.
AFAICT that would also mess with the drafts (e.g. not saving edits)...at least it did as I tried that...
As for the "why do it in the first place"-part...well, I for one couldn't care less about the space it might take up in the db...but I got other problems with this feature:
1. It foobars some of my plugins (e.g. twitter updating ones which will fire for both the "final" as for the "inherited" revision)...any hints on how you can differentiate between those at post time?
2. I don't see anything to use the revisions...yes they're present in the db, but there's no (G)UI element for them (e.g. to restore/go back one revision on a post)...or am I missing something?
define('WP_POST_REVISIONS', false);
Doesn't work. Large unwanted posts are simply added following every minor revision. My database has grown massively.
"I bet you're the kind of person who actually goes through and deletes old email too, right?" - Well, surprisingly yes; since I receive tens a day that makes very good sense.
This is a very blase approach that has resulted in the worst ever WordPress version change. The number of stored Revisions (0 in my case) should at very least be controllable. Quadrupling the size of my database with unwanted posts makes 2.6 unusable and already, my phpadmin imports (controlled by my host not me) have to be split into sections.
Bloody infuriating mess up of a blog tool I have always revered. I will try to revert to 2.5 until it is 'fixed'.
Otto, let's say you have 1000 posts, and in the process of your authors making those posts, they each make 5 changes. Suddenly you have 5000 items in the database. WordPress is notorious for using poorly indexed database files, which means there will be HUGE queries. Basically, this takes an existing issue (wordpress slows significantly past 10,000 posts) and makes it X number of times worse.
Revisions should be written to a seperate table where they aren't in the way of normal queries.
After every session, I run clean-up SQL:
Delete from wp_posts where post_type='revision';
It is hopefully a temporary inconvenience until some control is given to revisions; at the moment, it is an abortion.
It is another one of those mystery functions: It might be a good idea for some, but there isn't any reason why it shouldn't be optional.
My apologies, define ('WP_POST_REVISIONS', 0); DOES work.
When I tested, I was confused by the new auto_save which happens as a single 'revision'. I would rather not have this either but I can live with it; my main problem is that because of the nature of my site, large posts receive many minor revisions.
Posted 4 years ago #
Yo! Now I am happy.
By running clean-up SQL:
> Delete from wp-posts where post-status='revision'
and adding to wp-config:
> define ('WP_POST_REVISIONS', 0);
> define('AUTOSAVE_INTERVAL', 600); // One hour should be long enough!
I don't get masses of large unwanted duplication and I can simply click Save whenever I want to without having everything duplicated with unwanted auto-saves every minute.
It was BAD judgement that the majority of users would love this extra database content.
Same issue happened with the more tag in posts via rss, functionality was removed or significantly changed without reason, when this would be something best left for people to choose. I can't imagine it being very difficult to add in a "do you want to use post revision history" as an option in settings.
(oh otto, this isn't whining... it is constructive. When in doubt, programmers should always offer options rather than hardcoding their personal preferences into things. The options harm nothing)
Posted 4 years ago #
I can't imagine it being very difficult to add in a "do you want to use post revision history" as an option in settings.
No, it would not be difficult at all. It is, however, totally unnecessary as having post revisions has no downside to it.
The options harm nothing
Excessive and useless options harm usability and make systems confusing.
Otto, you are kidding me? No downside? Let's see, wordpress already has a number of poorly constructed queries that don't use indexes on the wp-post file, which in turn makes certain functions slow. Adding extra posts to that file (remember, not indexed, so they will have to be handled anyway) isn't a "no downside" issue. Adding potentially huge amounts of data to an active datafile that won't be used by 99.9% of the people who touch it (visitors to the blog will never see the revisions) isn't good design.
As for you options comment, I can't even answer, except to say "wow".
Posted 4 years ago #
Let's see, wordpress already has a number of poorly constructed queries that don't use indexes on the wp-post file, which in turn makes certain functions slow.
Easily remedied by adding indexes to the database, if needed. I've run it up to 20-30k posts and noticed no heavy slowdown with default settings. I admit that it would be nice if some of the more obvious indexes were added to the schema by default.
Adding potentially huge amounts of data to an active datafile that won't be used by 99.9% of the people who touch it (visitors to the blog will never see the revisions) isn't good design.
So, do you think that wiki's tracking all the history is a bad idea as well? Revision tracking is useful only in edge cases, I grant you, but I reiterate that space is cheap and even the edge benefits outweigh the extremely minor costs.
As for you options comment, I can't even answer, except to say "wow".
Why? That's an obvious principle of modern UI design. Do not make things too complex. Adding options that are largely useless is bad design. Disabling the revisions is largely useless. There's no real case to argue for disabling it. Your arguments do not support disabling it, they support fixing other issues (poor indexing, for example).
At much more than 10k posts, the display time for simple pages gets longer, searches because slower, and so on. In part, it is because of the query that selects the posts for display, it has always had a pretty major flaw in it's layout, the query is done in a way that makes the indexes pretty useless. I have added indexes to all the blogs I run just to be able to keep up with day to day, especially on the larger ones.
Adding significant numbers of extra records is never a good idea. Just correcting a typo is a new records. Notice 2 or 3 on seperate shots and suddenly you have 4 times the data for the same post.
Wiki is different from a blog, in that most of us are the only ones editing our own blog, or at most 2 or three people. Wiki had to add in an edit history mostly to deal with people defacing entries. Wikis are a very, very different game, and they use a significantly different methodology in order to avoid DB issues. It's like a car, putting a ferrari body on a yugo still leaves you with a yugo.
In the case of wordpress, it would have been better to add a table called wp_revisions, where the old post is written off to each time the edit screen is accessed. The only time you need to look at revisions is during admin time, your blog readers aren't checking your revisions and certainly you aren't showing them to the search engines. Those combine for 99.9% of all wp_post queries, so why do it any other way?
The reasons for disabling it? Because the vast majority of the people writing personal blogs don't need it. Most write a post and that's that, and they might fix a typo. They don't have 10 people coming in writing stuff, they aren't worried about anyone defacing a post, etc. I am sure that some people may use it to recover a post when they do something like accidentally remove a post, but for the most part it is going to be tons of data that most people will never use, and that will go stale almost immediately.
Modern UI design says "give the users the options", not "lock them into a single way of thinking". Using that logic, there would be no need for plugins or themes because we would just all use the one right theme that someone has selected for us.
Posted 4 years ago #
Why's post revisions turned on by default, btw?
Space is virtually unlimited, granted, but let's say I do have just a little paid space that currently runs "close to the wind", but still runs fine. With an upgrade to 2.6, possibly doubling your DB size, I'd have to buy another bunch of space just because I've updated to an unwanted feature.
Opt-In'ify this feature, and noone will ever complain again.
I think the revision system is great, and definitely an important step for WordPress in being used not only as a personal blogging system but also as a full featured CMS for larger organisations.
However, something I find very strange about the design now, not using a seperate table for the revisions, is that a lot of data is stored for nothing. All fields in the wp_post table that are not subject to the revision system (comment_count, ping_status etc.) are just duplicated and take up space for no reason. A seperate table could hold less fields and theoretically save loads of space and performance.
And at the very least the diff system (which is great btw) could be used to see if title or body text were changed with the edit. It might just be a custom field or something plugin related that was edited, and an entire new revision row is a waste of space.
(seems like the post ID is maintained, never mind my rant about the IDs).
I don't like the post revision feature as well. It's not an issue of whether I have enough space or not in the database for those extra entries. I simply do not need them. Thus these entries are gonna be sitting in the database, rotting away and collecting dust. Now that's not a very good use of resources is it?
I think that some sites (like what microkid mentioned) such as larger organisations would love the feature, but in any case, I think an option to turn it off would be great. That way, it'll satisfy all users. (:
Otto: I've always had good impressions of the main WP support team here, but sadly, you have tarnished that image. I think you just failed to understand that the majority of users are using WP for a simple blog and do not need the post revision feature. It is not about "SPACE IS CHEAP." Only a minority (when compared relatively) are using it as a full-fledged CMS.
Meanwhile, thanks for the temporary fix, Gamerz.
Ahh...Gamerz: I'm not sure if your fix is working. The IDs are still jumping whenever I edit something. I think all it does is to take away the "Post Revisions" portion from post.php. =/
And even auto-saves are now being assigned their own IDs? This is bad. =( Is there a quick fix we could use to undo this? (ie. go back to the 2.5 way of doing things.)
Posted 4 years ago #
Honestly, I really don't like the "Post Revision" feature. The reason has been told by other members, and I really wish there could be a choice to turn it OFF.
fantasycrusader, we were discussing the ID issue here, I found a solution that might help you.
Let's not forget all the good work the main development team has done all this time. Even though you might not be happy with this new feature or the way it's been implemented, the motivation behind it is clearly to make WordPress better. It's an open source community, so instead of pointing fingers, try to put your effort in coming up with ways how to improved it.
Posted 4 years ago #
I think the post revision feature is a great addition to the software, but must register my vote that it should:
1. be easy to enable/disable through settings
2. result in revisions being stored in a separate table, leaving only the most current version in the main posts table
I'd like to add that it might be nice to introduce some kind of pruning mechanism, so that revisions over X days are automatically removed (some might consider revisions over 28 days to be no longer required for example) or a maximum of Y revisions are kept. Naturally values would be user definable through the interface.
One of my installations is a prime example of a single-user system and I am a prime example of a user who always makes (multiple) minor adjustments to posts after they have been published, no matter how much I read and re-read the draft version.
I am on paid hosting, but space is limited and although a single revision doesn't take up a lot of space, effectively tripling or quadrupling the size of each post is a concern.
Thanks.
Posted 4 years ago #
Before reading this and similar threads I didn't even know the function is there. Only when I pay attention, I see that there are jumps in post ids. Besides that I don't need the function myself, I wonder what's the use of it, because I can't find where the revised posts are. Do I have to get them from the database manually or are they hidden in a place where I haven't looked? Why not just under "manage" and "revised posts" or something?
I bet you're the kind of person who actually manually goes through and deletes old email too, right? You really have to get over this "it takes up space" thing. Space is cheap and virtually unlimited. :)
No with my web host it isn't. I'm limited to how much I can store in a database. Also, every time I want to backup the database, I have to download the whole thing. If it grows larger and larger, full of revisions, I have to download much more.
Excessive and useless options harm usability and make systems confusing.
There's nothing excessive or useless about it. Why does WordPress have to go down the Microsoft "force users to do things exactly as well tell them" route? By all means, have an "advanced" options screen somewhere, or even just a text file with advanced options that non-technical users don't ever need to see.
There needs to be an option to disable autosave (at least when editing existing posts - for never published posts it isn't an issue).
There's no real case to argue for disabling it.
So many people asking how to disable it is a pretty good case. People don't want lots of extra entries in their database. Lots of plugins are broken now too because the meaning of a "post" in the database has changed.
There absolutely should be a button to turn it off. It has nothing to do with whether a particular person likes it or not. There are just certain options that beg to have an on and off button because users will be split on whether they want it or not. Customer service does not necessarily give an option when 1% want a feature. But I bet if turning it off was an option 1/3 of the people who thought about it would turn it off.
For the record, I sort of like the feature and probably would not turn it off unless I saw it impacting my site negatively in some fashion. But, I still think it should be there for those who do want it off.
The only thing I don't like is how it saves a backup even if I don't make any changes. Sometimes I open a page or post to look at something or copy something from the post. Then the next time I open the post, I get the big pink banner saying "There is an autosave of this page that is more recent than the version below. View the autosave". That is annoying.
It seems ridiculous that "those in charge" are refusing to add an option - just one small checkbox - for this because it makes WordPress "cluttered and confusing". Yet they were perfectly happy to add in a hugely confusing, obtrusive and wide-reaching feature such as revision control to WordPress in the first place.
If you don't like this feature and would like an option added, please go to WordPress Trac and add your support to ticket #7360.
This topic has been closed to new replies.
