How to get count of list items in SharePoint 2010 if count is more than List View Threshold value?

Question

I have more than 10000 items in my list. I have default List View Threshold value as 5000.I want to get the count of items programmatically. How can I get the count? I think here SPListItemCollection.Count won’t work.Is there any other methods?

List View Threshold size for auditors and administrators is 20000 by default.If i am administrator will i get the count from SPListItemCollection?

Answer 1

For this you need to increase the Threshold value first and then get the list item count. You can increase it either programmatically or powershell or Central admin.

Ex.. through powershell

$WebApplication = Get-SPWeb http://
$List = $WebApplication.Lists["My List"] 
$List.EnableThrottling = $false
$List.Update() 

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/95adcb1f-2b1e-4e26-b352-060731978f41/sharepoint-list-item-count-exceeds-the-threshold-limit?forum=sharepointdevelopmentprevious

Once you get the count revert it back.

http://blogs.msdn.com/b/dinaayoub/archive/2010/04/22/sharepoint-2010-how-to-change-the-list-view-threshold.aspx

Answer 2

You will be able to get the total count using the ContentIterator:

It queries the lists in batches and avoids the Throttling Exceptions:

static int exceptions = 0;
static int items = 0;

protected void OnTestContentIterator(object sender, EventArgs args)
{
    items = 0;
    exceptions = 0;
    string query1 = @"<View>
        <Query>
            <Where>
                <And>
                    <BeginsWith>
                        <FieldRef Name='SKU' />
                        <Value Type='Text'>S</Value>
                    </BeginsWith>
                </And>
            </Where>
        </Query>
    </View>";

    ContentIterator iterator = new ContentIterator();
    SPQuery listQuery = new SPQuery();
    listQuery.Query = query1;
    SPList list = SPContext.Current.Web.Lists["Parts"];
    iterator.ProcessListItems(list,
        listQuery,
        ProcessItem,
        ProcessError
    );
}

public    bool ProcessError(SPListItem item, Exception e) 
{ 
    // process the error
    exceptions++; 
    return true; 
}
public void ProcessItem(SPListItem item)
{
    items++;
    //process the item.
}

Answer 3

SPList.ItemCount property returns the items count of the whole list.

SPQuery query = new SPQuery(); // or SPQuery query = new SPQuery(view); copy query string from a view.
query.QueryThrottleMode = SPQueryThrottleOption.Override;
SPListItemCollection items = list.GetItems(query);
int count = items.Count;

Answer 4

Try using

//some query
var title = "<Eq><FieldRef Name='Title' /><Value>task 00001</Value></Eq>";
var q = "<Where>" + title + "</Where>";
var lst = web.Lists["Tasks"];
var query = new SPQuery
{
    ViewFields = "<FieldRef Name='ID'/>",
    QueryThrottleMode = SPQueryThrottleOption.Override
    Query = q,
    IncludePermissions = false,
    RowLimit = 20000
};
var items = lst.GetItems(query);
var count = items.Count;

as shown in this post

Answer 5

Using SPList.ItemCount property worked perfectly for me.

string dump = string.Empty;
foreach (SPList list in SPContext.Current.Web.Lists)
{
   dump += string.Format("List:{0}, Item count:{1}\n", list.Title, list.ItemCount);
}

Answer 6

No need for programmed solution. Open the list in SP Designer. Under "List Information" you will see a count total of items on the list.