The SharePoint team has published this awesome SharePoint Server 2007 Scalability and Performance whitepaper where they tested loading up SharePoint with 50 million documents. It outlines the architecture and testing methods they used to conduct the study.

Note that the team used VSTS web and load tests to load test the site.