News:

Picture posting is enabled for all :)

Main Menu

One more to go....

Started by Trevor_D, November 01, 2009, 14:05:21

Previous topic - Next topic

1066

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

1066


BarriedaleNick

Quote from: plainleaf2 on November 01, 2009, 22:24:20
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
Moved to Portugal - ain't going back!

ACE

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

BarriedaleNick

Quote from: ACE on November 02, 2009, 18:26:46
Betcha can't say that while you are rubbing your head and stroking your stomach  ;D

Depends on the wine intake  ;)
Moved to Portugal - ain't going back!

Trevor_D

Quote from: BarriedaleNick on November 02, 2009, 17:23:51
Quote from: plainleaf2 on November 01, 2009, 22:24:20
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

Quote from: Trevor_D on November 02, 2009, 19:34:33
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!
Moved to Portugal - ain't going back!

BarriedaleNick

Moved to Portugal - ain't going back!

asbean

The Tuscan Beaneater

Trevor_D

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

Quote from: Trevor_D on November 01, 2009, 14:05:21
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?


.


BarriedaleNick

Quote from: Trevor_D on November 02, 2009, 19:51:33
I think that was the point I was making three months ago when I started this thread....

Quote from: Trevor_D on November 01, 2009, 14:05:21
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.
Moved to Portugal - ain't going back!

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.  :) :) :)
The Tuscan Beaneater

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
MAY THE CORN BE WITH YOU.

Powered by EzPortal