locked
Large List RRS feed

  • Question

  • I've been reading the web and the MS Whitepaper on large lists and am confussed.

    ~ This is based upon a SharePoint 2007 farm. ~

    a. Can you have more than 2000 items in a single list, with no folders? (Loaded question as we have over 7000 items at present)

    b. Will the overall site see a performance hit because of the list size?

    c. If we limit the view to only display 100 items at a time is this acceptable? Meaning, I can deal with a little slowness (few seoncds) rendering to the screen. I can't deal with data loss and/or crashes.

    Thank you,

    Steve

     

    Friday, April 29, 2011 3:38 PM

Answers

  • To add, the Sofware Boundaries article for MOSS (http://technet.microsoft.com/en-us/library/cc262787(office.12).aspx) states that the 2,000 limit is related to items in a view of the list.  The list can handle more.  Your solutions above address the issue well, in that it keeps the count of those items low.

    - M


    - Michael Mukalian - 2010 MS MVP SharePoint Services - MCTS: MOSS 2007 Configuration - http://www.mukalian.com/blog
    • Marked as answer by David HM Thursday, May 5, 2011 8:57 AM
    Saturday, April 30, 2011 12:34 PM

All replies

  • a. You can. The 2000 limit is a recommended maximum  not a fixed limit.

    b. Overall site: No The list: yes.

    c. Provide several views and make the dfault view for that list one that will not take a long time. I have the latest 20 items only (no paging) as the default in some of my lists (see the sig). The lists or URL lists with several thousand entries so were much slower before having such a restrictive default view helps. Other Views however are predefined. Also note:  make sure grouping does not use the Expanded version as the View. etc.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters

    Friday, April 29, 2011 3:44 PM
  • To add, the Sofware Boundaries article for MOSS (http://technet.microsoft.com/en-us/library/cc262787(office.12).aspx) states that the 2,000 limit is related to items in a view of the list.  The list can handle more.  Your solutions above address the issue well, in that it keeps the count of those items low.

    - M


    - Michael Mukalian - 2010 MS MVP SharePoint Services - MCTS: MOSS 2007 Configuration - http://www.mukalian.com/blog
    • Marked as answer by David HM Thursday, May 5, 2011 8:57 AM
    Saturday, April 30, 2011 12:34 PM