1
vote
0answers
12 views

threshold plan ahead approaches

I would like to ask which are the approaches being used to plan list implementation taking scalability into account. I know that we can create indexes, subfolders, multiple views and so on, but that ...
0
votes
2answers
73 views

How to use an index with list view threshold

I have a list with 20,000 records that I have been trying to deal with. Threshold is at the default 5k. I was under the impression that if I index a column, filter on it, and my results are under 5k, ...
0
votes
0answers
71 views

ListViewThreshold Exception although column is indexed

I created a list with 30000 items. Next I made sure filtering on my "Text001" column returns less than 5000 records (4988 to be preceise). I verified that using the SPFarm administrator's account ...
1
vote
0answers
92 views

Understanding list view threshold (I expected an exception)

I created a list with numerous lookup columns (more than 12) and many many list items (more than 30.000). The "All List Items" view works perfectly. This is expected However I expected a sorting on ...
2
votes
1answer
232 views

Cannot retrieve all items from large SharePoint list via Excel data connection

I have a large SharePoint 2010 list (~60,000 items) in which the list view threshold has been turned off. Recently, we've encountered the problem that exporting the list to Excel only yields a subset ...
1
vote
1answer
2k views

How can I configure a View filter/index to go around the item threshold?

I want to create a paginated view that shows me ALL the items, 30 items at a time. I have a list with 8000 items. The item limit is 5000 items, so I got this error on the "All Items" view: This ...
0
votes
1answer
113 views

Large list - List view Threshold - SP 2010

For a project requirement client wants - saving 1 million document in a flat document library. Though document size is low, total data is not more than 9 GB. Due to Threshold settings can we store 1 ...
0
votes
1answer
331 views

Error exporting list to excel - permissions for resource throttling ceiling

What level of permissions have to be assigned to a user account in SharePoint 2010 for them to qualify as an "administrator" and therefore grant them access to the higher ceiling for resource ...
1
vote
5answers
2k views

Delete list in Sharepoint 2013 larger than 5000

I have created a sharepoint list in 2013 by importing an access 2013 table which has 7414 records and have set the list to sync with the table held on my local PC. I want to start over again but when ...
4
votes
1answer
427 views

SharePoint List View Threshold Error on Delete and Re-load of Data

Foremost, I am not an administrator of SharePoint site and have very limited controls on my page. Earlier, I had created a list (custom list with Datasheet view). I had created over 20 views (one ...
2
votes
1answer
746 views

delete large list in SharePoint2010

I have a List in sharePoint with 64095 items , I want to delete list completely , but I can't delete list beacuse of number of items. The error message is similar to: The attempted operation is ...
0
votes
2answers
268 views

increase List threshold or Custom Filter?

I have a list over 200,000 items in it. It's on normal threshold (2,000 items per view). Users want large threshold but there is price for that. SQL traveling/transaction, server overhead and the ...
3
votes
4answers
5k views

Error - while exporting a Sharepoint List (Export to Excel)

Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues. Note: He is ...