全文搜索慢SQL Azure的V12 [英] Fulltext search slow SQL V12 Azure

查看:163
本文介绍了全文搜索慢SQL Azure的V12的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

全文搜索终于支持在MS SQL Azure的服务器V12。它正常工作,但你运行一个搜索第一次是非常缓慢的。事实上超时经常。连续搜索运行速度非常快,虽然。似乎全文引擎加载到内存中。任何人都经历了同样的事情吗?

Fulltext search is finally supported in SQL Server V12 at MS Azure. It works as expected, but the first time you run a search it's immensely slow. In fact it times out quite often. The consecutive searches runs very fast, though. Seems that the fulltext engine is loaded into memory. Anybody experienced the same thing?

推荐答案

这有望在需要时(分词)启动FTS。

This is expected as the FTS (word breaker) starts when needed.

这篇关于全文搜索慢SQL Azure的V12的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆