Unimportant statistic of the day: the last post I made was the 22,222 post on this site (not just my page, the whole site.) That's not counting comments.
numbers are good to me, are we at 100K comments??
You'd think there might be more comments, but there's only 12,820. Lots gets written without comment.
Well, actually now that I look, there aren't that many posts. They are numbered sequentially, and the numbers are up to 22,222, but there are a lot of missing numbers. I guess these are all deletes. Wow. We delete tons of stuff. I can't believe it. There are really only 9651 posts. How could that be? I have to look into this more.
OK, I see why it is like that. In the old system the comments were in the same table in the database as the posts. Then when I rewrote the system I broke the comments out into their own table, but for backwards compatibility I had to keep the old id numbers on the posts. (The id is part of the url.) So this created lots of gaps in the early part of that 22,222 sequence.
I forgot about that. Looking right into the database is like doing cyber archeology (especially when you can't remember how you did things a couple years ago, but the code is still running.)
|
- jim 5-13-2003 8:05 pm
numbers are good to me, are we at 100K comments??
- Skinny 5-14-2003 3:59 pm
You'd think there might be more comments, but there's only 12,820. Lots gets written without comment.
- jim 5-14-2003 5:26 pm
Well, actually now that I look, there aren't that many posts. They are numbered sequentially, and the numbers are up to 22,222, but there are a lot of missing numbers. I guess these are all deletes. Wow. We delete tons of stuff. I can't believe it. There are really only 9651 posts. How could that be? I have to look into this more.
- jim 5-14-2003 5:30 pm
OK, I see why it is like that. In the old system the comments were in the same table in the database as the posts. Then when I rewrote the system I broke the comments out into their own table, but for backwards compatibility I had to keep the old id numbers on the posts. (The id is part of the url.) So this created lots of gaps in the early part of that 22,222 sequence.
I forgot about that. Looking right into the database is like doing cyber archeology (especially when you can't remember how you did things a couple years ago, but the code is still running.)
- jim 5-14-2003 5:33 pm