What is the record limit for a single table?

I've seen over 10M, but it really depends on the amount of fields and data types you are capturing with each of those records.  
More fields = more data (even if those fields are empty). 

It more of a size thing, and really it just affect performance and cost the bigger they get.