Wednesday, March 10, 2010

Large lists with list throttling

 

Feature

Maximum Limit 2010

Maximum Limit 2007

Number of items in a list or library

50 million per library

5 million per library

Size of an individual file item or item attachment

2 Gigabytes

50 MB (2 Gigabytes)

Item

5,000 per view

2,000 per view

Power Shall script to create Large list

$siteurl = “http://Faizal-PC”
$mysite=new-object Microsoft.SharePoint.SPSite($siteurl)
$spWeb = $mysite.OpenWeb()
$spList = $spWeb.Lists["powershell"]
$i = 1001
do { Write-Host “Item – “$i
         $spitem = $spList.Items.Add()
         $spitem["Title"] = $i.tostring()
         $spitem.Update()
         $i++
}
while ($i -le 7000)

image

To Setup Resource throttling go to Central Administration and General Setting and Select Resource throttling

image

Resource Throttling screen to setup Threshold

image

image

Go to List Settings and View the List threshold message. 

image

No comments: