Resources For IT Professionals

United States (English) Drop down arrow

Россия (Pусский)中国（简体中文）Brasil (Português)

Post an article

Wikis - Page Details

First published by Rodrigo Romano (2Microsoft Partne)
When: 16 Apr 2012 12:58 PM
Last revision by Maheshkumar S Tiwari
When: 6 Sep 2013 11:51 AM
Revisions: 2
Comments: 1

Options

Subscribe to Article (RSS)

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

SharePoint 2010 - Dealing with Large Lists - 5,000 items limit

If you need to handle a large amount of data, this article will be very handful.

First thing to keep in mind is the SharePoint Boundaries and Limits (http://technet.microsoft.com/en-us/library/cc262787.aspx) and this article Designing large lists and maximizing list performance http://technet.microsoft.com/en-us/library/cc262813.aspx.

According to SharePoint Boundaries and Limits, it's supported 30,000,000 items per list. That's a lot of information.

So, Why the 5,000 items limit?

That happens because the SQL Server limit of row locks. When you try to perform a operation to up 5,000 items, it's easier to SQL to do a Lock Scalation and temporary lock the entire table. When this happens very often, the users will experience a performance degradation. (For more info, see: http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx).