SharePoint list data operation improvements include core enhancements as well as the automatic creation of indexes on lists when necessary, and improved time to first byte.

In addition, SharePoint’s client object model is designed to be batched so that the number of round trips between the browser and the server are reduced to improve the overall performance of the client object model.

The use of Sandboxed Solutions allows for the monitoring and management of solutions at a site collection level to limit the negative impact of a poorly performing SharePoint Solution Package (WSP) file.

In addition to the performance monitoring and management for solutions, SharePoint 2010 monitors and manages large running queries via application level settings. These settings allow you to set limits and warnings when the number of records returned from a query is large. There is also an object model override that allows you to enabled developers to bypass these limits – and exclusion for a time during the day when the queries are allowed – so that large

reports can be generated in batch.