• Truncating Deleted Users

    From Poindexter Fortran@VERT/REALITY to All on Wednesday, May 27, 2015 10:25:23
    All,

    I have a bunch of deleted users in my user database, and when I select User->Truncate deleted users, I get a message that says 0 Deleted User Records removed. Should that option remove the deleted users and renumber the user file?

    I have a couple of new users at the tail end of the deleted users, and sbbsecho has to cycle through them when it runs.

    ---
    þ Synchronet þ realitycheckBBS -- http://realitycheckBBS.org
  • From Digital Man@VERT to Poindexter Fortran on Wednesday, May 27, 2015 17:00:04
    Re: Truncating Deleted Users
    By: Poindexter Fortran to All on Wed May 27 2015 10:25 am

    All,

    I have a bunch of deleted users in my user database, and when I select User->Truncate deleted users, I get a message that says 0 Deleted User Records removed. Should that option remove the deleted users and renumber the user file?

    No, that option only removed deleted user slots from the *end* of the user database. Renumbering the users would be bad.

    I have a couple of new users at the tail end of the deleted users, and sbbsecho has to cycle through them when it runs.

    If it's a big problem I guess you could just move those couple of new users, but their scan pointers and other BBS files linked to their user numbers will be wrong.

    digital man

    Synchronet "Real Fact" #71:
    Synchronet CIOXTRN (created by Deuce) is a 32-bit replacement for DOORWAY. Norco, CA WX: 73.6øF, 54.0% humidity, 9 mph ESE wind, 0.00 inches rain/24hrs

    ---
    þ Synchronet þ Vertrauen þ Home of Synchronet þ telnet://vert.synchro.net
  • From Poindexter Fortran@VERT/REALITY to Digital Man on Thursday, May 28, 2015 06:35:48
    Re: Truncating Deleted Users
    By: Digital Man to Poindexter Fortran on Wed May 27 2015 05:00 pm

    If it's a big problem I guess you could just move those couple of new users, but their scan pointers and other BBS files linked to their user numbers will be wrong.

    I only had a couple of users at the end of the user.dat listing (and a system user I use for Transx), so I removed them, emailed the users, recreated the system users and re-ran the option to truncate deleted users. That removed 1700 users from my user.dat file, and now the scan goes much faster.

    With the amount of traffic running through my system, more likely than not I'd have another BBS call in with mail and get two copies of sbbsecho. With the drop in scan time to reduce the overall time spent in my mailer batch file and a semaphore I wrote into my batch file, that problem is solved.

    Thanks for your help!

    ---
    þ Synchronet þ realitycheckBBS -- http://realitycheckBBS.org
  • From Digital Man@VERT to Poindexter Fortran on Thursday, May 28, 2015 16:39:45
    Re: Truncating Deleted Users
    By: Poindexter Fortran to Digital Man on Thu May 28 2015 06:35 am

    Re: Truncating Deleted Users
    By: Digital Man to Poindexter Fortran on Wed May 27 2015 05:00 pm

    If it's a big problem I guess you could just move those couple of new users, but their scan pointers and other BBS files linked to their user numbers will be wrong.

    I only had a couple of users at the end of the user.dat listing (and a system user I use for Transx), so I removed them, emailed the users, recreated the system users and re-ran the option to truncate deleted users. That removed 1700 users from my user.dat file, and now the scan goes much faster.

    With the amount of traffic running through my system, more likely than not I'd have another BBS call in with mail and get two copies of sbbsecho. With the drop in scan time to reduce the overall time spent in my mailer batch file and a semaphore I wrote into my batch file, that problem is solved.

    At least until you got a lot more users. :-)

    digital man

    Synchronet "Real Fact" #78:
    172 Synchronet Match Maker registrations were sold (@$69) between 1995 and 1996.
    Norco, CA WX: 79.7øF, 44.0% humidity, 4 mph E wind, 0.00 inches rain/24hrs

    ---
    þ Synchronet þ Vertrauen þ Home of Synchronet þ telnet://vert.synchro.net
  • From Mro@VERT/BBSESINF to Poindexter Fortran on Thursday, May 28, 2015 23:34:34
    Re: Truncating Deleted Users
    By: Poindexter Fortran to Digital Man on Thu May 28 2015 06:35 am

    user numbers will be wrong.

    I only had a couple of users at the end of the user.dat listing (and a system user I use for Transx), so I removed them, emailed the users, recreated the system users and re-ran the option to truncate deleted users. That removed 1700 users from my user.dat file, and now the scan goes much faster.


    a couple times a year i usually export the user file with location and pw to a text file and use makeuser to reimport them.
    i then nuke everyone's pointers,etc.

    comes in handy. i still wish synchronet 'packed' the deleted users, or atleast had the option to. i dont like having a user list filled with deleted accts. ---
    þ Synchronet þ ::: BBSES.info - free BBS services :::