White paper: Working with large lists in Office SharePoint Server 2007

Working with large lists: white pap...

Updated: 2007-07-24

Microsoft performed performance testing against Microsoft® Office SharePoint® Server 2007 to determine the performance characteristics of large SharePoint lists under different loads and modes of operation. This white paper presents their findings.

The test results in this white paper are intended to demonstrate the difference in the performance characteristics of SharePoint lists containing large numbers of items when different data access types are used to present list contents. Test results in this white paper show how to optimize list performance through limits on the number of items that appear in a list, and by choosing the most appropriate method of retrieving list contents.

Download this white paper as a Microsoft Word document (.doc).

White paper: Working with large lists in Office SharePoint Server 2007 (http://go.microsoft.com/fwlink/?LinkId=95450&clcid=0x409)

Tags

: sharepoint (x) Add a tag

Flag as ContentBug

Explanation of the Test1, Test2, Test3 along x axis of the graph

DenverSerrao | Edit | Show History

Great paper. Nice explanation of stress testing size limits of lists.

I was a little hazy on one of the details though. Can you clarify what the X axis represents on the various graphs. The Test Results section mentioned that each data point is the result of 25 tests. So statistically, these 5 points of 25 tests would be equal to 1 point of 125 tests?

Or is there some sort of trend data I'm missing along the x axis like increasing the size of the list? I ask because there is quite a big standard deviation in the results from Adding and Deleting data in 100K item lists.