sharepoint2010:The number of items in this list exceeds the list view threshold, which is 20000 item...

ist view threshold :	107806 items (list view threshold is 20000). The number of items in this list exceeds the list view threshold, which is 20000 items. Tasks that cause excessive server load (such as those involving all list items) are currently prohibited. Learn about managing a large list or library and ensuring that items display quickly.

sharepoint2010:找了N多方法，建INDEX,增大threshold，设置FILTER VIEW等。

效果都不明显，

那只好导出LIST，然后删除无用的LIST这方法了。

在SQL里搜索相应的LIST，并导出为EXCEL供审核。

~~~~~~~

测试语句，至于如何获得tp_ParentId号，新建一个LIST，自然可以知道。所有数据都在AllUserData表里。所以要查询。

1 select top 50 tp_Created,nvarchar1,nvarchar4 from AllUserData where tp_ParentId='A4CCCB83-FA83-4558-A88C-F919B6606699' order by tp_Modified desc

 

查询结果和导出操作截图如下：

转载于:https://www.cnblogs.com/aguncn/archive/2013/03/06/2945476.html