This is a link to a great post on some limitations of how big a site collection could/should get. Here is the article.