Copied to clipboard

Flag this post as spam?

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


  • trfletch 579 posts 555 karma points
    May 16, 2019 @ 16:27
    trfletch
    0

    Large Umbraco website intermittently slow

    We have a large Umbraco 7.5.4 website (over 160,000 nodes) and we seem to have intermittent issues with the website going slow and hanging, this can happen maybe once or twice a week.

    We have a database analyser running and it appears that the following SQL statement is causing the wait (see bottom of post).

    Does anyone know what calls this SQL statement and if anything can be done to resolve this and stop the website hanging?

    Just as a side note, we have "Umbraco.ModelsBuilder.Enable" set to "false" in the web.config to resolve another hanging issue with this version of Umbraco.

    We also have "ContinouslyUpdateXmlDiskCache" set to "false" as we used to experience issues with the umbraco.config file rebuilding and becoming corrupt as it was such as large file.

    The SQL statement that appears to be causing the wait is as follows:

    (@0 nvarchar(40)) 
    /* BEGIN ACTIVE SECTION (inserted by DPA) */  
    SELECT umbracoNode.id,  
       umbracoNode.parentID,  
       umbracoNode.sortOrder,  
       cmsContentXml.xml,  
       umbracoNode.level  
    FROM umbracoNode  
    INNER JOIN cmsContentXml  
    ON cmsContentXml.nodeId = umbracoNode.id  
    AND umbracoNode.nodeObjectType = @0  
    WHERE umbracoNode.id in  
       ( 
       SELECT cmsDocument.nodeId  
       FROM cmsDocument  
       WHERE cmsDocument.published = 1 
       )  
    ORDER BY umbracoNode.level,  
       umbracoNode.parentID,  
       umbracoNode.sortOrder 
    /* END ACTIVE SECTION (inserted by DPA) */
    
  • TheArtist 21 posts 42 karma points
    May 16, 2019 @ 19:18
    TheArtist
    0

    Helle trfletch ☺️

    My large site was also hanging / very slow. The CPU was in max our solution was to move all redirects to the IIS. We was using Urlrewrite.

    Are you using azure?

    /TA

  • Paul Wright (suedeapple) 221 posts 604 karma points
    May 16, 2019 @ 21:50
    Paul Wright (suedeapple)
    0

    Delete some nodes? :-)

  • John Bergman 429 posts 982 karma points
    May 17, 2019 @ 06:38
    John Bergman
    0

    We have intermittent speed issues as well on 7.14.0; hosted in azure.

  • trfletch 579 posts 555 karma points
    May 17, 2019 @ 07:29
    trfletch
    0

    @TheArtist All our redirects are already using IIS Url Rewrite.

    We are running on an Azure virtual server with the database running on a separate Azure virtual server.

    @Paul Write Deleting nodes is not an option, all the content that is on the site is needed.

Please Sign in or register to post replies

Write your reply to:

Draft