Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Phani 21 posts 70 karma points
    Oct 20, 2015 @ 11:17
    Phani
    0

    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

  • Ismail Mayat 4511 posts 10090 karma points MVP 2x admin c-trib
    Oct 20, 2015 @ 12:19
    Ismail Mayat
    0

    Phani, After moving to azure did you republish xml cache and re build indexes?

    Regards

    Ismail

  • Phani 21 posts 70 karma points
    Oct 20, 2015 @ 12:33
    Phani
    0

    Hi Ismail,

    Thanks for the reply.

    Yes I did. But it took lot of time to rebuild indexes.

    Many Thanks, Phani

  • Ismail Mayat 4511 posts 10090 karma points MVP 2x admin c-trib
    Oct 20, 2015 @ 12:46
    Ismail Mayat
    0

    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?

  • Phani 21 posts 70 karma points
    Oct 20, 2015 @ 13:31
    Phani
    0

    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

  • Ismail Mayat 4511 posts 10090 karma points MVP 2x admin c-trib
    Oct 20, 2015 @ 14:07
    Ismail Mayat
    0

    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

  • Ismail Mayat 4511 posts 10090 karma points MVP 2x admin c-trib
    Oct 21, 2015 @ 08:20
  • Phani 21 posts 70 karma points
    Oct 26, 2015 @ 07:52
    Phani
    0

    Thank you Ismail. I'll check this.

    Sorry for the late reply

    Many Thanks, Phani

Please Sign in or register to post replies

Write your reply to:

Draft