[Mediawiki-l] revisions table compression

[Jim Hu]

We would like to both cut down on the space used by the revisions table, and change the way we count user participation by compressing revision histories when users do multiple consecutive saves within a single short time.

In maintenance, I see that there are scripts to just delete specific revisions by id from the revisions table.  So, we're thinking that we would run a script to delete revisions based on some criteria, and also make an extension that hooks at ArticleSave
or ArticleSaveComplete to delete prior revisions by the same user if they are within a specified time period.

Before trying this, I thought I'd ask to see if 
- anyone sees potential problems.
- its been done already

Thanks!

Jim 

=====================================
Jim Hu
Associate Professor
Dept. of Biochemistry and Biophysics
2128 TAMU
Texas A&M Univ.
College Station, TX 77843-2128
979-862-4054