Has anyone ever thought about...
Home | Reviews and Features | Special Reports | Forums |

Page 1 of 2 12 LastLast
Results 1 to 15 of 23

Thread: Has anyone ever thought about...

  1. #1
    Join Date
    Oct 2001
    Location
    Coventry, UK
    Posts
    988

    Has anyone ever thought about...

    ... the possibility of "pruning" the database to get rid of the members that don't really visit anymore?

    I was looking at the discussions page and there's over 40,000 members supposedly registered. I can guess that a large majority of these rarely or never visit this board anymore.

    I don't really have an idea of how the vBulletin software works but am I right in thinking that the space taken up by the data could be detrimental to the performance of the database and the hardware running it?

    Just one of my many random thoughts...

    Jon
    A64 3200+ Venice | XP-120 | 1024MB GeIL Ultra PC4000 | Asus A8N-SLi Deluxe | Connect3D ATi Radeon X800 XL 256MB | 2x 250GB Maxtor DM+10 (RAID-0) | LG Flatron L1710B | 1999 Ford Mondeo Ghia X 2.5 V6

    "Oh Lord, grant me the senility to forget the people I never liked anyway, the good fortune to run into the ones I do, and the eyesight to tell the difference."

  2. #2
    Join Date
    Aug 2002
    Location
    39.4834 N 87.3261 W
    Posts
    658
    I did a search in the members section; this is what I came up with: About 89% of HWC members have not posted in over a year. 94% of HWC members have not posted in over 6 months. 83% of the members here have less than 10 posts.

    A fair amount of people come to HWC to ask a few questions and then leave to never return, and there's nothing wrong with that. I don't think however, that it's necessary to keep all of these people in the database. Is there and option on vBulletin to automatically delete these "members"?

  3. #3
    Join Date
    Apr 2000
    Location
    UK
    Posts
    8,466
    It's not worth the effort or potential hassle in my opinion. It's not as if storage is a common, limiting factor when it comes to messageboards - I/O and connectivity are far more important.

    MuFu.

  4. #4
    Join Date
    Aug 2002
    Location
    39.4834 N 87.3261 W
    Posts
    658
    Yea, MuFu you're probably right. It's not as though any of us spend much time searching through the member database. However, when you are trying to remember something that a person posted and can only remember the first letter or two of their name, it can be a mess trying the wade through the immense pile of members stored here (there are 72 pages of members listed starting with the letter "A" alone!) 71% of the members here haven't posted in over 2 years; surely those accounts can be deleted.

    If vBulletin has a feature to automatically trim these unused accounts, it wouldn't really be too much of a hassle at all. If it doesn't have that feature, then you can ignore us.

    Thanks for your time!

  5. #5
    Join Date
    Oct 2000
    Location
    Dallas, Tx.
    Posts
    2,668
    But surely you're not looking for a post that's two years old either.

    Search for the two initials and restrict the date range.

    Besides, the high member count helps sell ad space and keeps the site going.
    "Imagine a world where dogs took bad owners to the pound."


    http://www.hopeforpaws.org/

  6. #6
    Join Date
    Oct 2001
    Location
    Coventry, UK
    Posts
    988
    ah right, I see

    just a thought anyway...
    A64 3200+ Venice | XP-120 | 1024MB GeIL Ultra PC4000 | Asus A8N-SLi Deluxe | Connect3D ATi Radeon X800 XL 256MB | 2x 250GB Maxtor DM+10 (RAID-0) | LG Flatron L1710B | 1999 Ford Mondeo Ghia X 2.5 V6

    "Oh Lord, grant me the senility to forget the people I never liked anyway, the good fortune to run into the ones I do, and the eyesight to tell the difference."

  7. #7
    Join Date
    Sep 2002
    Posts
    823
    also, if you did delete accounts that hadn't posted in a long time, but had posted in some threads that are really benefitial and have not been pruned due to their content, how would you not delete their post but delete their name?

  8. #8
    Join Date
    Jan 1999
    Location
    Melbourne, Australia
    Posts
    8,796
    MuFu:

    It's not worth the effort or potential hassle in my opinion. It's not as if storage is a common, limiting factor when it comes to messageboards - I/O and connectivity are far more important.

    MuFu.
    Agreed.

    Besides, we get members returning after many months or even years wanting to retain their original user name and details as it is, let alone complicating it by saying, "sorry, we deleted you".

  9. #9
    Join Date
    Oct 2001
    Location
    US
    Posts
    1,157
    I agree with Bink there. Members return later after weeks or even months after they have registered. I'd think we would have pretty disappointed members if they returned and found out their account was deleted.
    Eric

  10. #10
    Join Date
    Aug 2002
    Location
    39.4834 N 87.3261 W
    Posts
    658
    I can see where there would be problems with it. Still, the overbloated member database bugs me. 59% of the members here have accounts with 5 posts or less and haven't posted in over 2 years, I don't think any of these people will come back after being away for more than 2 years and demand back their <5 post account! Also did you know that 23% of the members at HWC have 0 posts!

  11. #11
    Join Date
    Jan 1999
    Location
    Melbourne, Australia
    Posts
    8,796
    RDX:

    Also did you know that 23% of the members at HWC have 0 posts!
    There are some members who are happy to lurk. I wouldn't be surprised if lurkers take up a large portion of the registered members here. On that note, just because someone hasn't posted in a long time, doesn't mean they haven't visited at regular intervals since

  12. #12
    Join Date
    Aug 2002
    Location
    39.4834 N 87.3261 W
    Posts
    658
    Yes, but do you have to be registered to read the forums? Last time I checked it was just to post.

  13. #13
    Join Date
    Jan 1999
    Location
    Melbourne, Australia
    Posts
    8,796
    ...and to vote in polls and subscribe to threads so you can recieve notifications of new posts in particular topics/forums

  14. #14
    Join Date
    Aug 2002
    Location
    39.4834 N 87.3261 W
    Posts
    658
    Well maybe...possibly they....

    Oh all right! just forget the whole thing!!!



    BTW, I was a lurker here for over a year before I joined in the discussion.

  15. #15
    Join Date
    Oct 2000
    Location
    There and Back Again
    Posts
    380
    i don't post here that often, but i do read....


    like MuFu said, it's not worth the trouble

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •