在Sharepoint或SQL Server中存储> 10K行 [英] Storing >10K rows in Sharepoint or in SQL server

问题描述

解决方案 BCS比SharePoint列表有更多限制。 如果你只是想从BCS（SQL SERVER）读取数据，它应该没问题，但是你需要为它定义过滤器。 / span> 以下是一些链接供您参考。 https://technet.microsoft.com/en-us/library/cc262787.aspx?f=255&MSPPError=-2147217396 （ < span style ="color：＃1F497D">列出 和库限制 part） https://blog.devoworx.net/2013/01/01/external-list-limitations-in-sharepoint/ http://pravahaminfo.blogspot.sg/2012/01/business-connectivity-services.html BCS过滤器和分页。 https://blogs.msdn.microsoft.com/jysaikia/2010/12/15/a-step- by-step-guide-in-designing-bcs-entities-by-using-a-sql-stored-procedure / SharePoint：大型列表的最佳做法。 https://blogs.msdn.microsoft.com/svarukala/2017/05/07/sharepoint-best-practices-for-uploading-more-than-5000-items-to -a-librarylist-aka-large-lists / 最诚挚的问候， Lee 解决方案 Hi, BCS has more limitations than SharePoint list. While if you just want to read data from BCS(SQL SERVER), it should be fine, but you need define filters for it. Here are some links for your reference. https://technet.microsoft.com/en-us/library/cc262787.aspx?f=255&MSPPError=-2147217396 (List and library limits part) https://blog.devoworx.net/2013/01/01/external-list-limitations-in-sharepoint/ http://pravahaminfo.blogspot.sg/2012/01/business-connectivity-services.html BCS filter and paging. https://blogs.msdn.microsoft.com/jysaikia/2010/12/15/a-step-by-step-guide-in-designing-bcs-entities-by-using-a-sql-stored-procedure/ SharePoint: Best practices for large list. https://blogs.msdn.microsoft.com/svarukala/2017/05/07/sharepoint-best-practices-for-uploading-more-than-5000-items-to-a-librarylist-aka-large-lists/ Best Regards, Lee 这篇关于在Sharepoint或SQL Server中存储&gt; 10K行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！ 登录 关闭 扫码关注1秒登录 发送“验证码”获取 | 15天全站免登陆 友情链接： IT屋 Chrome插件 谷歌浏览器插件 IT屋 ©2016-2022 琼ICP备2021000895号-1 站点地图 站点标签 SiteMap <免责申明> 本站内容来源互联网,如果侵犯您的权益请联系我们删除.