Sunday, February 15, 2009

Working with large lists in Office SharePoint Server 2007

Microsoft published a very interresting white paper about working with large lists in moss:
http://technet.microsoft.com/en-us/library/cc262813.aspx
This white paper compare performance of differents methods that are used when working with SPList:
  • SPList with For/Each
  • SPList with SPQuery
  • SPList with DataTable
  • SPListItems with DataTable
  • Lists Web service
The results show that using SPQuery with indexed columns are recommended to improve performance of retriewing datas from large Sharepoint List.

No comments:

Post a Comment