locked
folder having more then 5000 documents gives error when it is viewed RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    I am working on document library that 2 folders. each folder has more then 5000 folders. document library has indexed on following fields.

    1.Created
    2.Modified
    3.Modified By
    4.Title

    UI gives below error when folder is navigated in "All Documents" view.

    "Your request was not able to return results because there are too many items in the current folder. To get results, navigate to a different folder or add a filter."

    To investigate further, I created a view that displays all the documents but without folder, this view works well. i am able to see the 6000th to 6030th using paging. i didn't apply any filtering here but i suppose i can view because doc library do have indexes.

    I am not able to understand why view gives above mentioned error when folder that has more then 5000 documents is viewed. could anyone please help me here.

    Regards Amit


    Thursday, May 2, 2013 10:30 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Amit,

    Absolutely throttling is not an option,But you need to scale out the ways for smooth performance.

    One option could be host your separate your site collection [which holding your document libraries] in different content DB in the SQL Server which meets your document libraries capacity]

    Murugesa Pandian.,MCTS|App.Devleopment|Configure

    • Marked as answer by Entan Ming Friday, May 10, 2013 3:04 AM
    Thursday, May 2, 2013 11:08 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Apart from increasing threshold level ,We can  Combine Filtering and Sorting to avoid hitting threshold . Kindly look into the following link

    http://shareden.blogspot.sg/2012/07/experimenting-with-large-sharepoint.html

    I hope it will be helpful for you

    Thanks.

    • Marked as answer by Entan Ming Friday, May 10, 2013 3:04 AM
    Thursday, May 2, 2013 12:28 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Amit,

    Document library and its operation heavily relays on SQL Server throughput performance.

    Please have a look on  "Capacity plan for document libraries" link and its worthwhile.

    Murugesa Pandian.,MCTS|App.Devleopment|Configure

    Thursday, May 2, 2013 10:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    just want to add one more line, we can't increase the throttling as it is not recommanded. production support will not agree for that.
    Thursday, May 2, 2013 10:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    hi Amit,

    First off 5000 folders? Time to rethink that structure you got there.

    Second, your issue, do you retrieve all the folders at once? If so then there is your issue. The view and SharePoint querying works based on items returned, in this case the folder is also an item, just a container item(SPFolder)

    Could you setup your view to display the folders but only return 30 items at a time, "Return Items in batches of X" where X is less than 5000.

    Regards
    Pieter
    Thursday, May 2, 2013 10:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    hi Pieter, thanks for reply.

    Document library doesn't have 5000 folders, actually folder has more then 5000 documents. there are only 10 folders in library.

    Regards amit K

    Thursday, May 2, 2013 11:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Amit,

    Absolutely throttling is not an option,But you need to scale out the ways for smooth performance.

    One option could be host your separate your site collection [which holding your document libraries] in different content DB in the SQL Server which meets your document libraries capacity]

    Murugesa Pandian.,MCTS|App.Devleopment|Configure

    • Marked as answer by Entan Ming Friday, May 10, 2013 3:04 AM
    Thursday, May 2, 2013 11:08 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Apart from increasing threshold level ,We can  Combine Filtering and Sorting to avoid hitting threshold . Kindly look into the following link

    http://shareden.blogspot.sg/2012/07/experimenting-with-large-sharepoint.html

    I hope it will be helpful for you

    Thanks.

    • Marked as answer by Entan Ming Friday, May 10, 2013 3:04 AM
    Thursday, May 2, 2013 12:28 PM