Slow SQL V12 Azure Full Text Search

Full text search is finally supported in SQL Server V12 on MS Azure. It works as expected, but the first time you run the search, it is very slow. In fact, this time is quite common. However, sequential searches are very fast. It seems like the full text engine is loaded into memory. Has anyone experienced the same?

+3


source to share


1 answer


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



+2


source







All Articles