We are planning to implement archiving/purging of user generated comments on blog. The only approach i can think about is, "The best practice would be to make sure none of the node has more than 1000 child nodes". So i can write a event handler which will be triggered on reaching 1000 comments and deletes the oldest comment.
Is this a good approach. I am not sure how archiving of comments happen any suggestions please!!!