Post #90.000

[GilesGuthrie]

Hey folks, I know it says (at the time I wrote this) 88,230 posts in the header, but I did Post #90,000 (see here ).

Cool huh!

 

[Jordan]

Whoa, now that's strange! I wonder what's up with the counter...

 

[GilesGuthrie]

My guess is that it's posts being deleted.

 

[Jordan]

Originally posted by GilesGuthrie
My guess is that it's posts being deleted.

Yep, you're right.

 

[piesupreme]

probably just the fact that every post made, equals a post deleted. forums reached maximum space, maybe?

 

[Jordan]

Originally posted by piesupreme
probably just the fact that every post made, equals a post deleted. forums reached maximum space, maybe?

There's not really a limit on the space, the postid number just indicates that that is the true number for posts on GTPlanet, whether the ones that came before it were deleted or not.

 

[GilesGuthrie]

Originally posted by piesupreme
probably just the fact that every post made, equals a post deleted. forums reached maximum space, maybe?

It's because the number of posts is a simple count of the number of records in the database, but the PostID is a unique, auto-incrementing counter that gets set when you post.

So, for example.
Post 1 = Good
Post 2 = Good
Post 3 = Bad
Post 4 = Good
Post 5 = Good

Number of posts = 5.
Index of last post = 5.

If the poster of #3 realises his post is bad, and then deletes it, we are left with:
Post 1 = Good
Post 2 = Good
Post 4 = Good
Post 5 = Good

Number of posts = 4.
Index of last post = 5.

But the next post's ID auto-increments from the last post, the table does not fill the gaps, so
Post 6 = Good

And there endeth today's SQL database lesson.

 

[Jordan]

Very nice, Giles!

 

[GilesGuthrie]

Originally posted by Jordan
Very nice, Giles!

Why thank you!