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.
And after index rebuild its still running slow? Also I recall the was examine for azure are you using that? Although not 100% if you need it in latest umbraco as its part of the core? Which version of umbraco are you using?
Yes the site is pretty fast after we rebuild indexes and can able to access all the pages in seconds, only the search results are taking lot of time to get the results.
Its an old site and we're using 4.7x version for this site
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
Phani, After moving to azure did you republish xml cache and re build indexes?
Regards
Ismail
Hi Ismail,
Thanks for the reply.
Yes I did. But it took lot of time to rebuild indexes.
Many Thanks, Phani
And after index rebuild its still running slow? Also I recall the was examine for azure are you using that? Although not 100% if you need it in latest umbraco as its part of the core? Which version of umbraco are you using?
Hi Ismail,
Yes the site is pretty fast after we rebuild indexes and can able to access all the pages in seconds, only the search results are taking lot of time to get the results.
Its an old site and we're using 4.7x version for this site
Many Thanks, Phani
Phani,
Take a look at this post https://our.umbraco.org/forum/developers/api-questions/56303-Status-of-Examine-and-Azure-blob-storage-providers also do more searching on forum for examine and azure as you think you will need to do a little bit more work.
Regards
Ismail
Phani,
Just seen this may apply to you https://our.umbraco.org/forum/core/general/60572-Site-slow-on-Azure-Websites
Thank you Ismail. I'll check this.
Sorry for the late reply
Many Thanks, Phani
is working on a reply...