Warning - Read Tracking is being cleared Nov 2, 2003

I am giving everybody a 3 day notice that your read tracking is going to be cleared this Sunday. Read tracking is what lets you know what new posts you have not read yet. Do to the extreme size this read tracking has taken up, we are clearing Read tracking this Sunday. This should improve the performance of the board as well. So for those of you who like to read every post, you might want to make sure you are caught up by 12:00 am Sunday.

thx for the warning

I am assuming this is because of the 1400 people who visited once, and it has been tracking ever since? You should put a cap on unactive people somehow or something.

Thanks for the notice.

yeah i think he's gonna run a querie at some point and remove any user
inactive for more than say 90 days. we'll see, because we really don't
want anyone to feel rejected or closed out of the site.

maybe not remove them, but clear their read tracking?

sorry, i was just talking about removing unused users, not just the read
tracking. that's gonna happen anyway.

maybe I am not understanding this...But the reason the read traqcking is so big right now is because it stores it all in the sql database, and there are so many unused users that it has been tracking for quite a while?

Why not just run a script every thirty days that clears the tracker for users who haven't used their account in the past thirty days?

Or am I confuseled?

i don't think you are confused...i htink you mixed 2 conversations into 1!
which btw, I think is a great idea. It's just we need someone to write
that script, now don't we?

hehehe I don't know how well I'd be able to integrate that security wise, but it really isn't anything to difficult script wise....I think

so I wont be able to come in every morning and go "view new posts"?

that sucks

no you will be able to
He is just dumping the database and starting fresh.

oh thats ok then

Well there you go BWM Musik ok'd it so go on ahead!

ahahahaaa ya smarty pants!!!! I thought he meant forever!!

Yeah this isn't forever. Just a one time dump since the read tracking is taking up 50+ megs in the database. What I am thinking about doing is writing a mod (since it doesn't exist) to make so the read tracking only tracks for the last 2 weeks. If anybody has any new posts that are over 2 weeks old then it would be cleared from the database as far as tracking is concerned. I think doing this will keep the file size down dramatically. Anyway, when and if that is implemented I will let everyone know.

Oh and down the road I may be clearing users from the table who are a few months old and have 0 posts.