Thursday, November 17, 2011

Performance issue with Project Task List in SharePoint 2007

Issue:
A Project Task List takes more than 5 minutes to load

Cause & Resolution:
·         User had a project task list
·         Total number of items = 2000+
·         She had created a custom view in which she selected an option Grouped by “Column Name”
·         Created my personal view (of course a standard view, no grouped by, no sort by or no filter)
·         Browsed the list using my personal view and it had hardly taken a minute to open
·         Also found this article - http://kb4sp.wordpress.com/2007/06/25/sharepoint-2007-hard-limitations/ which says – There is not a hard limit, but you might experience list view performance degradation as the number of field types in a list increases to 256 per list.
·         And I also checked when we select Grouped By option in the view Field types in the list increased to more than 300, so removed grouped by option from user’s custom view which loaded the list faster.

No comments:

Popular Posts

Disclaimer

The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.