Umbraco Examine search speed becomes too low with sql server in Azure

Hi All,

we’ve a umbraco site in which we’re using Examine search to search Documents, Pages and News articles.

We’ve a optimized code and the site is working well and we’re getting all the search results in seconds.

But when we move the database to Azure and changed the connection string to point to Azure database, it is taking ages to get the search results but all other pages are loading very fastly.

Can any one give suggestions on this?

Many Thanks,
Phani


This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/72288-umbraco-examine-search-speed-becomes-too-low-with-sql-server-in-azure