Fulltext search slow SQL V12 Azure

255 views Asked by At

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?

1

There are 1 answers

0
Satya_MSFT On

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