Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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:
/* BEGIN ACTIVE SECTION (inserted by DPA) */
INNER JOIN cmsContentXml
ON cmsContentXml.nodeId = umbracoNode.id
AND umbracoNode.nodeObjectType = @0
WHERE umbracoNode.id in
WHERE cmsDocument.published = 1
ORDER BY umbracoNode.level,
/* END ACTIVE SECTION (inserted by DPA) */
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?
Delete some nodes? :-)
We have intermittent speed issues as well on 7.14.0; hosted in azure.
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.
Deleting nodes is not an option, all the content that is on the site is needed.
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted