Strictly talking about overall project size, there seems to be a fairly high ceiling. In MC4 and MC6, I've worked on features that go well beyound 5 GB's, and some as high as 12GB. There doesn't seem to be a really noticeable difference in performance as the project size increases, unlike something like Final Cut Pro 7 that had major problems