Ticket #82 (WontFix)Sat Oct 28 22:09:31 UTC 2006
RForum shadow User database sweeper
Reported by: | Andrew Hodgkinson (6) | Severity: | Enhancement |
Part: | Web site: Beast (forum engine; forum pages) | Release: | 2nd public site release |
Milestone: | 2nd public site release completed | Status | WontFix |
Details by Andrew Hodgkinson (6):
RForum maintains its internal User database automatically now, adding entries when new Hub users visit the forum for the first time while logged in. If a Hub user deletes their account, though, the RForum account persists because Hub doesn’t know about RForum (and shouldn’t have to either). If the user made any forum posts there are two options:
(1) Delete their posts (discussions could become inconsistent)
(2) Orphan the account by clearing the e-mail field, as when a Hub user with a duplicate e-mail address but new ID logs in.
For users without forum posts, consider deleting their User record in RForum to keep the database size to a minimum. An external sweeper program with access to both Hub and RForum databases would be required. This operation would not need to be done frequently – on the order of months or even per-year, in all probability.
Changelog:
Modified by Andrew Hodgkinson (6) Mon, March 12 2007 - 00:40:18 GMT
RForum has been replaced by Beast, but the same problem – such as it is – exists. While migrating data to the new database, I did see examples of stubbed out user accounts where individuals had changed Hub account details with the same e-mail address. These entries were still being used in relation to posts. The number of dead entries with no associated posts was tiny, so while there still ought to be some kind of cleanup mechanism added sooner or later, it doesn’t seem to be needed too urgently.
Modified by Andrew Hodgkinson (6) Thu, October 09 2008 - 18:49:05 GMT
- Part changed from RForum (old forum engine, no longer used) to Beast (forum engine; forum pages)
Modified by Andrew Hodgkinson (6) Mon, March 14 2011 - 23:39:49 GMT
- Status changed from Open to WontFix
This just isn’t an issue in practice. New user accounts number in the hundreds a year on the ROOL site at most; in comparison, the Wiki has over 8,500 revisions stored in it. The storage space for the User objects isn’t a big issue and the database is designed to perform well with orders of magnitude more records. Closing this with “WontFix”.