全文搜索性能低下

你好

我在Azure SQL数据库上的全文查询遇到了问题.表格包含的行数少于15,000，并且本地查询只需眨眼(不到1秒)即可执行，而在我们的测试环境中，查询时间要长3到6倍.有什么办法吗 调查这是否与天青基础设施有关?当前，我们的数据库最大程度地利用了我们当前计划中拥有的50％的资源.我阅读了以下主题:https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e3215a8d-2433-41a7-a447-326cdc943410/sql-azure-fulltext-search-really-slow?forum = ssdsgetstarted 看起来和我们的情况类似.

I'm facing issues with my full text queries on Azure SQL Database. Table contains <15k rows and locally queries are executed with a blink of an eye (less than 1second), whereas on our test environment it takes between 3-6 times longer. Is there any way to investigate whether it is something related to azure infrastructure? Currently our database maximally utilizes 50% of resources that we have in our current plan. I read this topic: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e3215a8d-2433-41a7-a447-326cdc943410/sql-azure-fulltext-search-really-slow?forum=ssdsgetstarted which looks similar to our case.