No way are there 36,000 people posting on SF. How many do you really think are regular and would it be desirable to automatically remove members who haven't posted for a while (eg a year).?

....or not? :huh:

Don't forget those silly people who have duplicate ID's

I didn't start posting for about 8 months after I joined, I was a lurker :D

Never thought about how many, but here's a chance to say the new forum ticker on the home page makes me think there something crawling accross my pc :hihi:

Dunno.

We prune off dead accounts every few months.

We could probably do some really fiddly SQL statements to see how many people have posted in such and such a timescale but we can't be bothered. :)

Every now and again we kill off a 'dead' account only to have the user return two days later saying 'I need to post and can't!'. As the user data doesn't take a vast amount of room up, we let it ride but, like I said, we do have some heavy clean up sessions every now and again when the user count drops like a rock. :)

Typically I reckon we get about 2000 individual users a day active on SF, but different users from day to day, if that makes any sense at all. :)

We also get a few 'spammers' every day who sign up and get banned immediately, but their accounts get purged with all the other 'dead' ones.

The latest user ID issued is 41072, so the difference between that and the user count is the number of accounts we've binned.

and would it be desirable to automatically remove members who haven't posted for a while (eg a year).?

....or not? :huh:

why would it be desirable to do this?

We could probably do some really fiddly SQL statements to see how many people have posted in such and such a timescale but we can't be bothered. :)


Tch! you just can't get the staff these days :hihi:

what do you tell advertisers about numbers?

No way are there 36,000 people posting on SF. How many do you really think are regular and would it be desirable to automatically remove members who haven't posted for a while (eg a year).?

....or not? :huh:

No it wouldnt, just because you dont hear from a friend or relative for sometime, doesnt mean you are never going to see them again.
From what I have seen on here, when someone has not posted for a while, and then returns, they are made most welcome. :thumbsup:

As for advertisers, ask geoff. :)

We have obviously got statistics available - but we just tend to keep them to ourselves. :)

I'd be suprised if out of that 36,000 more than 500 post on a regular basis.

DELETE FROM LIVE.SFORUM
WHERE LST_UPD_DT < (CURRENT_TIMESTAMP - 1 YEAR)

That sort of thing should do the trick.

DELETE FROM LIVE.SFORUM
WHERE LST_UPD_DT < (CURRENT_TIMESTAMP - 1 YEAR)

That sort of thing should do the trick.

Ummm....given that half the Admin team are IT professionals I THINK we can manage. ;)

But thanks anyway!

We could probably do some really fiddly SQL statements to see how many people have posted in such and such a timescale but we can't be bothered. :)


Yep, you definitly sound like IT professionals!!

Yep, you definitly sound like IT professionals!!

He's not been here a day and he already has the Admin team sussed :hihi: :hihi: :hihi:

He's not been here a day and he already has the Admin team sussed :hihi: :hihi: :hihi:

It's more a case of takes one to know one!!

I personally don't post regularly but still view a couple of times a week to see what is taking peoples interest.
There are many who are not registered who drop in for a look these must increase hits on the sf many times more than the membership

Yep, you definitly sound like IT professionals!!

It was the 'can't be bothered' bit that gave it away, wasn't it? :D

It was the 'can't be bothered' bit that gave it away, wasn't it? :D

Probably, I got someone else to read it for me though.

I'd be suprised if out of that 36,000 more than 500 post on a regular basis.

What you trying to say :suspect: I have a life .. really I do! :D

Probably, I got someone else to read it for me though.

Now YOU definately sound like you work in IT :suspect: