SP2013 BCS-由于数据库查询花费的时间太长，外部数据的全文本搜索已超时 [英] SP2013 BCS - Full text search on external data is timing out due to db query taking too long
问题描述
在那儿，
Hi there,
背景:
我创建了一个SP2013外部内容类型并将其连接到外部SQL数据库，以便在该外部存储库上进行搜索.该数据库非常庞大且杂乱无章，但
由于资源限制，不能更改甚至不能部分迁移到新数据库.
I have an SP2013 external content type created and connected to an external SQL database for the purpose of searching on that external repository. The database is very large and disorganised but
cannot be changed or even partially migrated to a new db due to resource limitations.
ECT正常工作，数据从外部列表显示在SP2013中.我已经成功检索了所需总数据的一个子集(子集为1Tb，总计约为21Tb)，并且搜索结果
上来是正确的. ECT仅具有读取项目操作(包括inc doc元数据)，读取列表操作(也仅限元数据)和自定义操作，以使用StreamAccessor提供到文档二进制文件的链接，以进行全文搜索.
The ECT is working correctly, data showing in SP2013 from an external list. I have successfully crawled a subset of my total data needed (subset is 1Tb, total is about 21Tb) and the search results
coming up are correct. The ECT has only a read item operation (inc doc metadata), a read list operation (metadata only as well) and a custom operation to provide a link to the document binary using StreamAccessor, for full text search.
我一直在进行有限/过滤的查询以进行测试，但今天我在SQL Management Studio中测试了无限制查询并接管了一个小时，我取消了它.我知道SQL是否接受这个
很长一段时间，SharePoint爬网将失败，并显示LOB错误或太大或损坏".
I've been running limited/filtered queries for testing but i tested the unbounded query today in SQL Management Studio and to took over an hour, whereby I cancelled it. I know if SQL takes this
long, SharePoint crawl will fail with a LOB error or "too big or corrupt".
这是问题:
Here's the question:
如何有效地将SQL查询分页为可管理的批处理，而SharePoint搜索却像正常的无人值守的完全爬网一样继续进行?或正在搜寻大型外部存储库
使用SharePoint搜索服务是不可能的吗?
How can I effectively page the SQL query into manageable batches, while SharePoint search just continues like it does for a normal unattended full crawl? Or is crawling a large external repository
with SharePoint Search Service just not possible?
希望有人对我有答案或想法，感谢您的阅读！
Hoping someone has an answer or an idea for me, thanks for reading!
E
推荐答案
嗨eyccrooii，
Hi eyccrooii,
您是说您在SharePoint中进行了全文搜索以获取外部数据的结果，但是它返回了超时错误?
Do you mean that you did a full text search in SharePoint to get the results of external data, but it returns the time out error?
如果是，是否可以在管理中心->管理服务应用程序->搜索服务应用程序->抓取日志中得到结果?
If so, whether you could get the result in Central Administration->manage service applications->search service application->crawl log?
此外，检查外部数据是否超出索引限制，将导致不返回结果.
Besides, check if the external data exceeds the limit of index with will cause the result to not be returned.
https://technet.microsoft.com/en-us/library/cc262787.aspx
最诚挚的问候，
Grace Wang
Grace Wang
这篇关于SP2013 BCS-由于数据库查询花费的时间太长，外部数据的全文本搜索已超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
