SharePoint 2010 - Changes in Custom Lists, and Some Limitations of Custom Lists

SharePoint 2010 - Changes in Custom Lists:

SharePoint 2010 has introduced following changes in the Custom Lists:

• New events - WebAdding, WebProvisioning, ListAdding, ListAdded, ListDeleting, ListDeleted
• Site Collection events
• Synchronous "after" events to perform post-processing
• Custom error pages
• New property PSEventPropertiesBase to store the user name and token of the person who triggered the effective action
• New integrity constraints based on the lookup
• Projected Fields - fields from the parent which are referenced and displayed in the child list
• Lists Join - via LINQ, CAML, SharePoint Designer and API (SPQuery.Join and SPQuery.ProjectedFileds)
• Max 50M items under the read scenario
• List query size threshold - return warning or exception of query result exceeds threshold number of records
• Threshold pre-set is 5000 items for the normal user and 20000 items for the Super User
• List Administrators are notified when lists exceed threshold
• List constraints - max 8kb of data per list item (excluding attachments), 6 projected fields on joins (except using the view fields)
• Columns can be flagged as UNIQUE (must be indexed)
• Columns can be validated using custom field or by other fields

SharePoint 2010 - Some Limitations of Custom Lists:

SharePoint 2010 provides better performance for the Custom List, however it still have some limitations which are listed below:

• Maximum number of List Items is 50 million
• Max of 8kb of data per list item (not including attachments)
• Max of six projected fields allowed on joins