none
Large list - List view Threshold - sharepoint 2010 RRS feed

  • Question

  • 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 million doc ?

    If it is not recommended what are the issues outcomes?

    How Threshold comes in to picture? what is the role of Threshold ?

    If SharePoint does not recommend 5K doc in a library is SharePoint good option as CMS product while others allow much more.

    Pl share your view.


    • Edited by Mdh22 Friday, June 7, 2013 4:48 PM
    Friday, June 7, 2013 4:30 PM

Answers

  • Have you already read 'Designing large lists and maximising list performance'? http://technet.microsoft.com/en-us/library/cc262813%28v=office.14%29.aspx

    If not it is well worth your while.

    To answer some of your questions directly;

    Yes you can store up to 30,000,000 documents in one library but you need to be careful for obvious reasons.

    The threshold view is to prevent a single query sucking down so much resources that it effectively causes a denial of service attack on your farm. The query cost of basic operations like SPList.Items scales linearly, i.e. if it takes 0.2 seconds to process 5,000 complicated list items then it takes 2 seconds for 50,000 items or 1 minute 40 for 25 million items.

    SharePoint is a very good tool but it's not perfect, then again that's true of a lot of other CMS tools too. When you're dealing with that sort of content size you have to be careful no matter what platform you use.

    • Marked as answer by Mdh22 Friday, June 7, 2013 4:47 PM
    Friday, June 7, 2013 4:43 PM

All replies

  • Have you already read 'Designing large lists and maximising list performance'? http://technet.microsoft.com/en-us/library/cc262813%28v=office.14%29.aspx

    If not it is well worth your while.

    To answer some of your questions directly;

    Yes you can store up to 30,000,000 documents in one library but you need to be careful for obvious reasons.

    The threshold view is to prevent a single query sucking down so much resources that it effectively causes a denial of service attack on your farm. The query cost of basic operations like SPList.Items scales linearly, i.e. if it takes 0.2 seconds to process 5,000 complicated list items then it takes 2 seconds for 50,000 items or 1 minute 40 for 25 million items.

    SharePoint is a very good tool but it's not perfect, then again that's true of a lot of other CMS tools too. When you're dealing with that sort of content size you have to be careful no matter what platform you use.

    • Marked as answer by Mdh22 Friday, June 7, 2013 4:47 PM
    Friday, June 7, 2013 4:43 PM
  • Have you already read 'Designing large lists and maximising list performance'? http://technet.microsoft.com/en-us/library/cc262813%28v=office.14%29.aspx

    If not it is well worth your while.

    To answer some of your questions directly;

    Yes you can store up to 30,000,000 documents in one library but you need to be careful for obvious reasons.

    The threshold view is to prevent a single query sucking down so much resources that it effectively causes a denial of service attack on your farm. The query cost of basic operations like SPList.Items scales linearly, i.e. if it takes 0.2 seconds to process 5,000 complicated list items then it takes 2 seconds for 50,000 items or 1 minute 40 for 25 million items.

    SharePoint is a very good tool but it's not perfect, then again that's true of a lot of other CMS tools too. When you're dealing with that sort of content size you have to be careful no matter what platform you use.

    What should be steps for designing document library with large number of files? How to plan for large number of documents? pl guide.

    Saturday, June 8, 2013 3:52 AM
  • Are you getting something like 

    The number of items in list exceeds the list view threshold, which is 5000 items.  Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.

    Below mentioned discuss few solutions :

    List View Threshold 


    Friday, October 25, 2013 8:39 AM
  • Sometimes you might face a situation where you get this error:

    9239 items (list view threshold is 5000)

    The number of items in list exceeds the list view threshold, which is 5000 items.  Tasks that cause excessive server load (such as those involving all list items) are currently prohibited.

    Resolution :

    http://sharepoint.asia/list-view-threshold/

    Tuesday, October 29, 2013 10:44 AM
  • When designing the structure consider using multiple document libraries. For example you could have one Library for Drawings, one for Project plans etc. This will reduce the chance of going over the view threshold. As the other answers have stated it isn't so much the number of documents in the library that is the probably as how many documents can be displayed in a single view.

    Cheers, Mark E.

    Wednesday, May 17, 2017 2:54 AM