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)

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

Resource Throttling screen to setup Threshold

Go to List Settings and View the List threshold message.