9

The Proposed Question Sandbox on meta.codegolf.stackexchange.com, formed by a merge of 14 questions, currently has 510 answers (don't worry, it's all under control!). I'm worried that if there is a maximum, it might be reached.

I was previously concerned that the number of answers may be stored as an 8-bit integer, and hence the limit would be 256, but this is obviously not the case.

Is there a maximum number of answers to a single question? If not, is this because the databases use an integer type of arbitrary size? If yes, what causes it (the use of 32-bit integers, say)?

Improve this question
2

1 Answer 1

Reset to default
10

There is no limit other than the limits on the total number of posts in site.

An answer is a type of post, but one with a parent question foreign key. When displaying a question, all answers are retrieved with a SQL join.

Post ids use the int type, limiting sites to 2,147,483,647 (2 billion plus change) posts.

Improve this answer
0

You must log in to answer this question.