“Handle with Care “ – SharePoint Lists with Large lists

Here are few key things to remember when implementing SharePoint applications with high volumes of data.

    1. Never try to override List View Threshold. Keep it to 5000 as it is by default.
    2. Try avoiding increase of “List View Lookup Threshold”, keep it as 8
    3. Apply indexes to relevant columns. Be mindful about the content of column before adding indexes
    4. Use out of the box webparts as much as possible. Utilize parametrized list view webparts, connected webparts etc to achieve advance filtered listings
    5. Make sure to use indexed columns as much as possible in CAML queries
    6. Make sure to prioritized CAML query filters depending up on number of items filter out by each clause
    7. Avoid using People fields for CAML query filtering (anyway those are not index-able)
    8. Don’t rely on lookup columns heavily.
    9. Make sure you filter only the required set of list items
    10. Try using SPListItem.GetItemById whenever an Items being retrieved
    11. Avoid using SPQuery to make queries, instead user ContentIterator so that there will be less locks in DB
    12. If required, use caching(possibly ASP.Net Cache) when custom code is being used
    13. Off load processing from server as much as possible


      Some more tips by Amit Phatak at http://navigatingsharepoint.blogspot.com/2010/08/sharepoint-2010-handling-large-splists.html

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s