vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Pruning inactive/spam users (https://vborg.vbsupport.ru/showthread.php?t=324467)

XYZ500 02-17-2017 05:20 AM

Pruning inactive/spam users
 
Okay, so apparently there are tons of users who have never made a post and haven't logged in for a long while so I'm guessing they were spam/inactive and stuff like that so we are thinking about pruning all these users who have never made a post.

1. What happens to user IDs of other users when all these users get pruned? Will their user IDs remain intact?
2. Are there any benefits of doing this action? This will decrease the 'total members' count by a significant number but will there also be any kind of benefits? Just wondering.

cellarius 02-17-2017 05:30 AM

Quote:

Originally Posted by XYZ500 (Post 2582491)
1. What happens to user IDs of other users when all these users get pruned? Will their user IDs remain intact?

Not sure what you're asking here. But no, they won't stay intact - the users are deleted from the database. The id will cease to exist. If you're asking if that id will be used again (as in will vB fill in the gaps): No, it won't. All ids are auto increment. It's always last entry id +1.

Quote:

2. Are there any benefits of doing this action? This will decrease the 'total members' count by a significant number but will there also be any kind of benefits? Just wondering.
Hardly. You lose a little of database size, but nowadays that just doesn't matter. Unless you're pruning really, really many users you won't notice a difference.


All times are GMT. The time now is 11:07 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04576 seconds
  • Memory Usage 1,709KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete