SharePoint with Large lists is common scenario in any Sharepoint deployment. While there are Several blogs / Guidance TechNet articles which exist working /Managing Large lists, My blog is particularly about the "List view lookup Threshold"
Here is a table summarizes information about resource throttles and limits that you need to be aware of. These throttles and limits are set on the Resource Throttling page in Central Administration
Threshold or Limit |
Default value |
Description |
List View Lookup Threshold |
8
12**
|
Specifies the maximum number of join operations, such as those based on lookup, Person/Group, or workflow status columns. If the query uses more than eight columns, the operation is blocked. However, it is possible to programmatically select which columns to use by using maximal view, which can be set through the object model
This is for SharePoint 2013 Post June 2013 CU update . Refer to Note at end of this Article for Details . |
This feature limits the number of joins that a query can perform. Each lookup column in a list view causes a join with another table. Each additional lookup column in a view increases the complexity of metadata navigation and list view queries. By number of joins, I mean the number of Lookup, Person/Group, or Workflow Status fields that are included in the query. So for example, if you have a view that displays 6 lookup columns, and filters on another 3 distinct lookup columns then by default that view won't work, since the List View Lookup Threshold is 8, and the view is attempting to use 9 lookups.
Here are few observations which affect this threshold , which may cause either the request to hit the threshold limit & hence be throttled or may lead to the views showing data beyond the threshold limit configured in central Admin
1. What classifies as Lookup columns: Standard lookup columns, single-value managed metadata, multiple-value managed metadata, single-value people and group columns, and multiple-value people and group columns , Workflow Status , Created by , Modified by ( people ) are obviously counted as lookup columns .
2. Additionally following columns shows on list view also work as lookup columns , Name ( linked to Document) , Link (Edit to edit item) , Name ( linked to Document with edit menu), type ( icon linked to document)
3. We allow overriding the query throttling in following circumstances
a. User is browsing when the system is in an Unthrottled Time window ( Web application throttling settings)
b. The current user is a box administrator (part of local admin group on the machine where the request is served from) . Local admin privileges can also be obtained by being part of an AD group which in turn is a part of local or Domain Admins groups . you can use the following command prompt to dump the group membership of a logged on user on a particular Machine /workstation .
C:> WhoAmI /Groups
c. The user is browsing using farm admin/Application Pool account for the Web-application .
We highly recommend that you do not increase this number beyond the Default Threshold Limit , because through thorough testing we've observed that there's a serious non-gradual performance degradation that shows up above 8/12 joins. Not only does the throughput that the server can handle drop significantly at that point, but the query ends up using a disproportionately large amount of the SQL Server's resources, which negatively affects everybody else using that same database. Here is an article which talks about more on the Performance impact http://technet.microsoft.com/en-us/library/ff608068(office.14).aspx
References:
Working with Large Lists in SharePoint 2010 - List Throttling
SharePoint 2010: How to Change the List View Threshold and Other Resource Throttling Settings
Manage lists and libraries with many items
** Note : The List view Lookup Threshold has been revised to Default of 12 in SharePoint 2013 , after applying the June 2013 CU update . http://support.microsoft.com/kb/2817414
Any new Web-Application created will have List View Lookup Threshold set to Default =12 , While the values on Existing Web-apps needs to be modified Manually .
相关推荐
Error response from daemon: Get https://registry-1.docker.io/v2/: dial tcp: lookup registry-1.docker 一通百度,发现原来是dns服务器的错误,把服务器改成8.8.8.8或者114.114.114.114即可 具体做法: vim /etc/...
主要介绍了解决-BASH: /HOME/JAVA/JDK1.8.0_221/BIN/JAVA: 权限不够的问题,需要的朋友可以参考下
解决docker报错dial tcp lookup registry-1.docker.io
介绍用虚拟机安装Linux系统
https://viewdns.info/ https://dnslytics.com/ http://dnsspy.io/ http://leafdns.com/ https://dnsdumpster.com/ https://intodns.com/ http://www.zonecut.net/dns/ http://xip.io/ https://nip.io/ ...
用友手册资料:ECA-LOOKUP DATA手册.pdf
在终端启动gedit命令或者vscode命令报错:gedit: symbol lookup error: /home/chujie/anaconda3/lib/libgobject-2.0.so.0: undefined symbol: g_date_copy 问题分析: 导致错误的原因应该是gedit依赖libgobject-2.0....
https://geoapi.qweather.com/v2/city/lookup?{查询参数} // 你的KEY:访问控制台-项目管理,点击创建项目,随后可获取key https://devapi.qweather.com/v7/weather/now?location=101010100&key=你的KEY
-ef exclude file file is a list of exclude dirs/files - one per line -version print version, licence and copyright message Source1 source2 ... are the source directories/files containing the ...
资源包含两个jar包,一个是httpclient,一个是httpcore. http接口需要的jar包,可以查看博客:https://blog.csdn.net/qq_25814003/article/details/80749287
回答了在unix的C编程中容易碰到的问题和编程经验,包含进程控制、一般文件操作、终端输入/输出、系统信息和编程杂技等等,是不可多得的好资料
【亲测可用】Revit 2020 Lookup Tables是Revit表格查找工具,是revit开发必不可少的一个组件,需要的朋友可以下载! 用法:将RevitLookup.addin和RevitLookup.dll放到C:\ProgramData\Autodesk\Revit\Addins\2019下...
-- lookup parent from repository --> </parent> <groupId>com.example</groupId> <artifactId>demo</artifactId> <version>0.0.1-SNAPSHOT</version> <name>demo</name> <description>Demo project for Spring ...
revit开发必备工具 本包中是已经编译过的文件,可以直接使用 ...编辑其中RevitLookup.dll 路径为编译路径 C:\RevitLookup-2016.0.0.6\CS\bin\Debug\RevitLookup.dll 重启revit: 即可在菜单栏看到工具
哪个模块 查找需要require()d的模块对象 在require.cache找到require()或import ed的module对象-本质上是对require()的反向查找。 对于想要例如查找其本身require()本身的模块或子模块的文件名的库很有用。...
dnslookup 简单的命令行实用程序即可进行DNS查找。 支持所有已知的DNS协议:纯DNS,DoH,DoT,DoQ,DNSCrypt。 如何安装 使用自制程序: brew install ameshkov/tap/dnslookup 来自来源: go get github....
#ifndef __LIST_H__ #define __LIST_H__ struct list; struct list *list_init();...int list_lookup(struct list *list, int value); int list_indexof(struct list *list, int value); #endif /* __LIST_H__ */
使用lookup选项 const http = require ( 'http' ) ; const CacheableLookup = require ( 'cacheable-lookup' ) ; const cacheable = new CacheableLookup ( ) ; http . get ( 'http://example.com' , { lookup : ...