What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 122 Stack Exchange communities.

I can see that every StackOverflow question has its own id, but how can I see which question is the question #1,000,000? In general: How can I find out the serial number of a question?

Update: As I get it now, is "serial number" the wrong expression. I'm asking for the first question which will let the total question count climb the million number range.

share|improve this question
add comment

4 Answers

Yes, I don't think it is that easy either. There isn't any property of a question that would make it obvious. The question number is approaching 4 million right now. I assume that the question count is fairly heavily cached, far too expensive to calculate for every page refresh. So the storm of page refreshes when it gets close isn't going to show the winner. And it is very dynamic with questions getting deleted all the time, #1M can be (will be) #999,999 a second later.

Knowing the SO team, I bet they've programmed some kind of custom trigger that flashes a Unicorn page up for at least 5 minutes so the number is stable for at least that long. Looking forward to it, hope it's a good question. And have the honor to get the answer mark for it :)

share|improve this answer
add comment

Here's a data explorer query to find question number n. This doesn't include deleted questions.

share|improve this answer
    
Cool! Never know about this. –  splash Oct 9 '10 at 21:39
    
Note that if deleted question are not counted, the answer will change in time. –  dmckee Oct 10 '10 at 1:46
add comment

Wel if you're talking 1,000,000 for the database Id then you can see the question here http://stackoverflow.com/questions/1000000

share|improve this answer
3  
This is just the 1 millionth post (could be answer or tag-wiki). –  KennyTM Oct 9 '10 at 20:48
    
Well, it is the question number in this case, but it is an year old and counts other posts too. –  Kobi Oct 9 '10 at 20:51
    
The database ID counts questions and answers alike. It is already above 3 million –  Pëkka Oct 9 '10 at 21:00
add comment

You can probably see it in the blog.
I'm not how you can find it yourself. You can probably use the data dump to find the nth question, but it doesn't include deleted posts. Without deleted posts, you can't have a nth question.

share|improve this answer
add comment

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .