Re: SPv2 List Size Limit

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Derek Martin (dmj2195_at_DONTSPAMMEokstate.edu)
Date: 02/27/04


Date: Fri, 27 Feb 2004 09:34:53 -0600

This seems silly. Not that I don't believe MS, but I have a list with
upwards of 35,000 records in it without any problems...I take it isn't a
hard limit? If it begins to 'degrade,' are there any benchmark numbers?

Thanks,
Derek

"Nigel Bridport [MSFT]" <nigelbri@online.microsoft.com> wrote in message
news:eU739oQ$DHA.3804@TK2MSFTNGP09.phx.gbl...
> Please refer to the latest WSS Administration Guide available from
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-a6a4-3e33fa13d230&DisplayLang=en
>
> Object Scope Limit Comment
> Site collections Database 50,000 Total throughput degrades as the
> number of site collections increases.
> Web sites Web site 2,000 The interface for enumerating subsites of
a
> given Web site does not perform well much beyond 2,000 subsites.
> Web sites Site collection 250,000 You can create a very large
total
> number of Web sites by nesting the subsites. For example, 100 sites each
> with 1000 subsites is 100,100 Web sites.
> Documents Folder 2,000 The interfaces for enumerating documents
in
> a folder do not perform well beyond a thousand entries.
> Documents Library 2 million You can create very large document
> libraries by nesting folders.
> Security principals Web site 2,000 The size of the access control
> list is limited to a few thousand security principals, in other words
users
> and groups in the Web site.
> Users Web site 2 million You can add millions of people to your
Web
> site by using Microsoft Windows security groups to manage security instead
> of using individual users.
> Items List 2,000 The interface for enumerating list items does
not
> perform well beyond a few thousand items.
> Web Parts Page 100 Pages with more than 100 Web Parts are slow to
> render.
> Web Part personalization Page 10,000 Pages with more than a few
> thousand user personalizations are slow to render.
> Lists Web site 2,000 The interface for enumerating lists and
libraries
> in a Web site does not perform well beyond a few thousand entries.
> Document size File 50 MB The file save performance degrades as
the
> file size grows. The upper limit is about 50 MB. This limit is enforced by
> the system, but the limit can be changed by the administrator.
>
>
> Nigel.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
>
> "Derek Martin" <dmj2195@DONTSPAMMEokstate.edu> wrote in message
> news:%23pm0zqK$DHA.2592@TK2MSFTNGP10.phx.gbl...
> > Hi there, does anyone know the number of items a SharePoint List can
> > handle...thousands, millions, infinite?
> >
> > Thanks,
> > Derek
> >
> >
>
>



Relevant Pages

  • Re: Sharepoint list maximums?
    ... In looking at the 2,000 for list items I would ... > Web sites Web site 2,000 The interface for enumerating subsites of a ... > given Web site does not perform well much beyond 2,000 subsites. ... > Lists Web site 2,000 The interface for enumerating lists and libraries ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Cannot complete this action - Error
    ... Could not edit columns on a list, could not add choices to a choice drop down list, could not import a spreadsheet. ... i did some checking and my Sharepoint Central Admin web site is running under a separate application pool from the default web site. ... the application pool used for the default web site is running under a Local Administrator account on the server. ... I am still able to access all site pages and data and I'm able to create new lists and add items to existing lists. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: How can I print a list of files within a folder?
    ... PrintFolders has been available for download ... from my web site for some time. ... "Jay Freedman" wrote: ... prevent people from printing lists of files. ...
    (microsoft.public.word.docmanagement)
  • Re: Visual Studio 2005 IDE
    ... When I start a new VB web site there is no problem. ... followed by all the controls, LinkButton1, Label1 etc. ... frustrated because a my fellow developers lists all show the controls on ... Select Reset All Settings, then click Next ...
    (microsoft.public.vsnet.ide)
  • Re: How can I print a list of files within a folder?
    ... Stick with the version on my web site. ... prevent people from printing lists of files. ... some of the important bits have been removed from Outlook. ... "Jay Freedman" wrote: ...
    (microsoft.public.word.docmanagement)