SharePoint Tip #22. Do you know “how to manage large list performance”?

When a list or library has a large number of items, you must carefully plan its organization and how users need to access the data to help preventing adverse effects on performance.

For best performance, do not exceed 2,000 items in a list level. For example, the root of the list or a single folder. In case if you must create and browse large lists, use the following best practices.

1,,) Create Indexed Colum

An index on a column enables Microsoft Windows SharePoint Services 3.0 to quickly analyze the data in that column, even when working with thousands or millions of items

2) Use only one Indexed Column in view

3) First column that is used to filter the view must have  an index

4) Change the default view of the list to a customized filtered view that follows these recommendations:

•    The view returns fewer than 5,000 items.
•    The first column that you use to filter the view has an index that sufficiently reduces the total number of items returned.
•    The view displays only those columns that are absolutely required.
•    The view includes as few lookup columns as possible. Each lookup column in a list that is included in a view causes an additional join and additional calls to the database.


Have anything to add?! Send your tips to be published via this form

1 Comment »

  1. mojgan behravan Said,

    June 17, 2009@ 5:21 am      Reply

    it was nice topic..thank you so much

RSS feed for comments on this post · TrackBack URI

Leave a Comment