Datasheet

SoFtware limitationS
|
35
Table 1.1 contains the software boundaries for this version of SharePoint.
Table 1.1: Software boundaries for SharePoint Foundation 2010
Object Maximum value Type of object Details
Zone 5 per web
application
Web application
limit
This limit is hard-coded per web application
as Default, Intranet, Internet, Extranet, and
Custom.
List Row Size 8,000 bytes per row List and library
limits
Each list or library item can take only up to
8,000 bytes (actually 7,744) in the underlying
database.
File Size 2 GB List and library
limits
The default maximum file size that can be
uploaded is 50 MB, but that can be changed.
The absolute maximum is 2 GB.
Bulk
Operations
100 ops per bulk
operation
List and library
limits
The user interface only allows for a maxi-
mum of 100 items to be selected at once for
bulk operations (such as copying to a library
from Explorer view).
ECT (External
Content Type)
in Memory
5,000 per web
server
BDC service limit Only 5,000 different ECTs can be in memory
per server at any given time.
External
System
Connections
500 per web server BDC service limit The default maximum is 200, but the bound-
ary is 500.
Table 1.2 describes a number of the software thresholds for SharePoint Foundation. Remember
that thresholds are default settings, many of which can be changed. These thresholds are suggested
for best performance.
Table 1.2: Software thresholds for SharePoint Foundation 2010
Object Maximum value Type of object limit Details
List View
Lookup
8 join operations
per query
Lists and libraries limit Any list view can only have eight
lookup fields (and that includes
People And Groups and Workflow
progress fields). More than that
will be blocked. Can be changed
in Resource Throttling per web
application.
626382c01.indd 35 1/27/11 10:47:26 AM