I heard this second hand, so please keep that in mind. I was recently at a standards meeting where the scalability of Sharepoint was discussed. Someone told me that the limit of storage in a Sharepoint server is around 1 million content objects. They also said that Microsoft was proud of the fact that in the next release it would be able to go up to 10 million objects.
Please let me know if you have seen otherwise! Let me know your Sharepoint scalability stories.
If it's true, 1 million objects is not terribly impressive. I understand the problem is trying to store stuff into blobs in SQL server. It makes sense to store content into blobs for some use cases, but not all. That's we made it optional both in Documentum and in Alfresco. The primary model for both is to store content into files to allow streaming, operating system caching and minimize database cache collision.