I've got a large vBulletin forum (~12 million posts) and my postedithistory table has grown to almost the same size as my post table (close to 6GB). I have a couple of questions.
1) I want to TRUNC the postedithistory table because selectively pruning it times out the database.
Can I disable PEH in vBulletin Options and then just TRUNC the table, then re-enable PEH and have it start tracking from scratch?
2) Is there a way (or future plans for) a date limit on PEH? For example, a user keeps editing their first post every day over a period of months... With the current system, it would log each and every edit, but is there a way, or are there plans for a way to set a limit (say 10 edits)? That way, before adding the next PEH entry, it could remove the oldest edit? Or, some kind of date limit?
__DEFINE_LIKE_SHARE__