如何迅速找出SharePoint中的List Item数量超过2000的Large List?

根据白皮书<<White paper: Working with large lists in Office SharePoint Server 2007>>, List Item数量大于2000的列表在UI上展现的时候, 会有性能差的问题.

 

那么如何找出一个SharePoint的Content DB中这样的列表呢?

 

运行下面的查询语句就可以了.

SELECT ItemChildCount + FolderChildCount as Items, 
        DirName +'/' + LeafName as RelativePath 
FROM alldocs WITH (NOLOCK) 
WHERE ItemChildCount + FolderChildCount >1500 
ORDER BY Items DESC 

 

这个查询可以返回文件夹和列表项总数超过1500的列表.