Just wondering:

  • Does the question_id monotonically increase for every new question?
  • Is the question_id unique globally for a deployed app or is it unique in some sub-domain?
  • Is there any relation between a question_id and the tags which are associated with the question?
  • Any correlatation to any other fields related to the question?
  • 1
    Chacha has it on the nose. You really shouldn't rely on this information though, as it falls firmly under the 'implementation detail' heading. – Kevin Montrose May 26 '10 at 22:54

So, basically:

Questions and Answers both use the same ID count. This means that the first question on a site would be ID 1. Then, the first answer is ID 2 and the second is ID 3. Then the next question on the site is ID 4. This keeps going.

This means that if you take the most recent post (question or answer), the ID will be the number of answers and questions that have ever been posted to the site. (Including deleted)

| improve this answer | |
  • So, in answer to the latter three points, no. – Tom Wright May 26 '10 at 22:24
  • Awesome, thanks guys. How about comments? Do they use the same ID count? – Alienfluid May 26 '10 at 23:10
  • 1
    @Alienfluid - comments are on a different index, so no. But once again, I wouldn't rely on that behavior. – Kevin Montrose May 26 '10 at 23:23

You must log in to answer this question.

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