Craft's Content Table I'm essentially in the process of learning Craft and in that process have made some great strides. 

Today I was examining Craft's tables to see how it was actually storing fields created through Settings-> fields. To my surprise most fields end up as a new column in the content table. To me this seems like a serious flaw as there is a very real limit to the size a table can grow to.

Given this information; what is recommended for developing a site in Craft that needs to have many fields?

If you have an answer I'd appreciate it. Please make it detailed. I'm at a loss with this one. Hopefully there is something I'm missing because if no... Craft may not be the solution I'm looking for. Which would be unfortunate.

Thanks
MySQL has a hard coded limit of 4,096 columns per table, although that can be effectively limited by the data types of columns involved.

Matrix fields get their own tables, so they don't count against the craft_content table.

But yes... if you're planning on having non-Matrix fields in the 2,000 - 4,000 field range, then there's a chance you'll bump into MySQL limitations.