Topic: One more to go....

[1066]

someone could always set up a user id "Mrs Ace" to get to 9000 (or whatever)   ;D

[BarriedaleNick]

the numbers have nothing to do with people or posts.
the the numbers are database object id numbers.

Technically wrong.

They are table indexes not database object id numbers.  A database object is a schema, table, query etc. - the numbers we are discussing do not refer to database objects - the refer to indiviual records within a databse object.
If a sequential index scheme is in place, which I believe is the default, then the first post will have an index number of 1. Likewise the first registered user will have an index on 1 in the user table. 

Allowing for live testing we can expect that the actual first user will have an id > 1 (assuming the indexes were not reset) and Dan may have setup test accounts so the number we see maybe a few out from the real number of registered users but generally speaking the ID you see represents how long you have been registered.
The same applies to the table dealing with posting. 

All you have to do to prove this is look at the message ids in the links on the home page.  They are ordered on time of posting and the message ids go down by one per post.

The message ID of this post will be 569995

[ACE]

Betcha can't say that while you are rubbing your head and stroking your stomach  ;D

[BarriedaleNick]

Betcha can't say that while you are rubbing your head and stroking your stomach  ;D

Depends on the wine intake  ;)

[Trevor_D]

the numbers have nothing to do with people or posts.
the the numbers are database object id numbers.

Technically wrong.

They are table indexes not database object id numbers.  A database object is a schema, table, query etc. - the numbers we are discussing do not refer to database objects - the refer to indiviual records within a databse object.
If a sequential index scheme is in place, which I believe is the default, then the first post will have an index number of 1. Likewise the first registered user will have an index on 1 in the user table. 

Allowing for live testing we can expect that the actual first user will have an id > 1 (assuming the indexes were not reset) and Dan may have setup test accounts so the number we see maybe a few out from the real number of registered users but generally speaking the ID you see represents how long you have been registered.
The same applies to the table dealing with posting. 

All you have to do to prove this is look at the message ids in the links on the home page.  They are ordered on time of posting and the message ids go down by one per post.

The message ID of this post will be 569995

You mean you don't know??

[lolabelle]

just wondering whos 666 ;D ;D ;D

[BarriedaleNick]

You mean you don't know??

Im not sure that I dont know but I am sure that I am uncertain about my knowing..
Actually it depends on teh wine intake!

[BarriedaleNick]

just wondering whos 666 ;D ;D ;D

http://www.allotments4all.co.uk/smf/index.php?action=profile;u=666  ;D

[asbean]

just wondering whos 666 ;D ;D ;D

http://www.allotments4all.co.uk/smf/index.php?action=profile;u=666  ;D

Well, they didn't last long, did they  ::) ::) ::) ::) ::)

[Trevor_D]

I think that was the point I was making three months ago when I started this thread....

We have 8999 members! One more to go to the next thousand....

But - more to the point - how many of those 8999 actually post anything?

[.]

  . = 10067    :o

[BarriedaleNick]

I think that was the point I was making three months ago when I started this thread....

We have 8999 members! One more to go to the next thousand....

But - more to the point - how many of those 8999 actually post anything?

I guess Dan has all the stats and could publish them if he chose but there is no reason why he should do so really.  I guess a few hundred regular posters, may be lots more who post infrequently.  In my experience you get a lot of ussers registering just to ask speciifc questions and then never posting again.

[Froglegs]

The other day i got a PM from a member who as not posted on A4A since 06, with an answer to my Cabbage post,this is not the first time this person as done this.I have asked why they they don't post anymore but have had no reply.
 

[asbean]

Interesting, if you look at the members list you can click on the column heading and they will be sorted according to that heading (click on the number of posts and the most poster (Tim) comes out on top)  There are 178 pages of members, and there are over 90 pages of members who haven't posted at all.  In fact the "number of posts" that is most frequent is 1, which means that the majority of people who register as members either don't post or just post the once.

But that doesn't mean they don't visit the forum, there is no obligation to post.  :) :) :)

[Froglegs]

I just find at odd that they go to all that trouble PM you  ??? why not just post it.

[1066]

I know what you mean froglegs I've had a similar pm  :-\

I've also had pm's from people who have never posted and on the same day they registered they asked for free seeds  ;D

[cornykev]

I'm tenth on the most posts list, I must push on a bit if I'm to get a Champions league place.    ;D ;D ;D ;D ;D