I am looking to prune the database table for post ratings. This database is 2.17 GB in size which is causing issues using the rating system.
Right now there is 361,289 negative post ratings. There are 34,356,666 positive post ratings.
#1 The easiest route. Delete all post ratings and we can start from scratch again. Active posters can rate each other up until they are back to where they were.
#2 Easy route. Delete ratings from a certain date on back.
#3 Still easy. Delete all negative ratings however this won't clear enough out, we'll need to combine this with something else.
#4 Not as easy. Delete ratings for users that haven't posted in a certain amount of time. This will require some cross checking from the post database table.
#5 ? Suggestions.