List Threshold and throttling is a new feature in SharePoint 2010 lists. This allow SharePoint administrator to block running heavy queries on SharePoint Lists which has thousands of items. In SharePoint 2007 the max items that can be returned by a list view was about 2000 items and any query over that number can result in low performance and load on the server. SharePoint 2010 lists has been optimized to support millions of items all together but provide SharePoint Administrators control over how many items are being retrieved from the lists at a time using User Interface or Object Model.
See the example below as we have a list with 6000 thousand items. The default threshold limit is 5000 which can be changed in the Web Application Settings.
Gulf Developer Conference will held on 13, 14 and 15th of December in Riyadh and I will be there. But a question is “What I will be doing there?”. The anwer to this question is pretty simple.
- I will be Leading the Microsoft Technical Community Lounge
- According to Microsoft “This event will be driven by the community” so we will doing many small presentation, events, chit chats, technical discussion and signups for our communities. I will be leading the place as RSUG Lead with Muhammad Halabi Taking DLS Lead.
- Building Dashboards with SharePoint… the good, the bad, the ugly
- SharePoint 2010… what every developers needs to know!
- Happy with SharePoint 2007?… things you need to know about SharePoint 2010!
- Microsoft SharePoint Server 2010: What’s in it for Developers
- Visual Studio Tools for SharePoint 2010
There will be many raffle draws for different gifts during the event so please make sure you visit the community booth for get them. Also take part in the chalk talk session to get the interesting learning experience.
By the way. GDC is free you can register and join us for the event without paying a single penny.
Looking forward to see you there.
SharePoint 2010 Lists support Field Validation which enables you to validate the values. Field Validation allow you to “specify the formula that you want to use to validate the data in this column when new items are saved to this list. The formula must evaluate to TRUE for validation to pass. “
Example: If your column is called "Company Name" a valid formula would be [Company Name]="My Company".
To Test out the Validation go to the List and Select List from List Tools