SharePoint 2010 - 列表视图阈值：什么不会触发阈值？
在 SharePoint 2010 中，我们有列表视图阈值，默认为 5,000，并且：
指定数据库操作（例如查询）在管理员设置的每日时间窗口（查询不受限制）之外可以同时处理的列表或库项目的最大数量。
因此，我希望确定用于查询项目数超过阈值限制的文档库的选项。
忽略“无限制”的日常时间窗口，在超过 5,000 个项目的文档库上，以下场景是否会触发阈值？
- 在内容查询 Web 部件中对索引列、非分页结果使用 CAML 查询 （答案：是）
- 在内容查询 Web 部件中对索引列、分页结果、每页 100 个使用 CAML 查询（答案：如果使用 ContentIterator，则否。否则，是/也许（取决于检索方法））
- 在索引或分页结果上使用搜索 API非索引列（答案：否）
In SharePoint 2010, we have the List View Threshold, which defaults to 5,000, and:
Specifies the maximum number of list or library items that a database operation, such as a query, can process at the same time outside the daily time window set by the administrator during which queries are unrestricted.
So, I'm looking to determine the options for querying a document library that will have more items than the threshold limit.
Ignoring the 'unrestricted' dailty time window, will the threshold be triggered under the following scenarios on a document library with more than 5,000 items?
- Using CAML Queries in Content Query WebParts on indexed columns, non-paged results
(Answer: Yes) - Using CAML Queries in Content Query WebParts on indexed columns, paged results, 100 per page (Answer: If using ContentIterator, No. Otherwise, Yes/Maybe (depending on retrieval method))
- Using the Search API on indexed or non-index columns (Answer: No)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我还没有找到好的文档，其中包含触发阈值限制的操作的“有限列表”。但这篇博文很好： http://blogs.technet.com/b/speschka/archive/2009/10/27/working-with-large-lists-in-sharepoint-2010-list-throtdling。 aspx
但我会考虑通过管理中心增加阈值限制，因为如果您的列表/文档库超过阈值，就会开始发生异常情况。例如，您可能会被阻止执行此操作，因为访问这么多项目可能会对网站的其他用户产生不利影响。
就第三点而言 - 我会说“不”，因为搜索 API 不会直接查询列表，而是查看自己的索引，并且对此没有实际限制！
另一个非常有用的资源：http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx#_Toc264017710
始终建议使用 ContentIterator，它提供了迭代列表项、列表、站点的方法，以调节传输的数据量（即，避免抛出 SPQueryThrottledException）。此外，此培训视频将帮助您回答一些问题： http://msdn.microsoft.com/en-us/sharepoint/ff420380.aspx#lesson2
I have not found good documentation which has "finite list" of operations that triggers the threshold limit. But this blog post is good: http://blogs.technet.com/b/speschka/archive/2009/10/27/working-with-large-lists-in-sharepoint-2010-list-throttling.aspx
But I would consider increasing threshold limits via Central Administration because if your have list/document library exceeding the threshold, unusual things starts occuring. For example, you may be blocked from doing this operation because accessing that many items could adversely affect other users of the site.
As far as No 3. is concerned - I would say "NO" because the search API does not query the list directly but it looks into its own index and there is no practical limit on that!
Another very useful resource: http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx#_Toc264017710
It is always advised to use ContentIterator which provides methods to iterate list items, lists, sites to regulate the amount of data that is transferred (i.e., to avoid throwing a SPQueryThrottledException). Also, this training video will help you a lot in answering some of your questions: http://msdn.microsoft.com/en-us/sharepoint/ff420380.aspx#lesson2