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
Hi,
Currently I have a site, where there are about 30K nodes under a node.
And publishing of content under this node takes a long time (2 mins). Is it possible to speed up the publising?
I am running version 6.1.4 of umbraco.
Thanks
Hi Domm123
That sure is a lot of nodes - I'm no database expert but perhaps you could gain some performance by adding indexes to the database?
Perhaps you can benefit from trying out the stuff that Mikkel Johansen writes about in this topic by me: http://our.umbraco.org/forum/developers/extending-umbraco/42361-This-is-a-bit-dirtybut-I-need-to-mess-with-the-database
Before you get a go at it make sure to make a backup etc.
Hope this might help.
/Jan
Hi Jan,
Thanks for your reply.
I have tried to run Mikkel Johansen script. But the performance is still the same.
I am suspecting the bottom neck to be the web server, rather than the SQL sever. (Seeing high CPU usage on w3wp).
Here are some facts:
1. Publishing of data on other nodes (which have lesser siblings) are still very fast.
2. Saving of content on the problem nodes are still fast.
3. Saving and Publising through the API for the problem nodes are very slow as well.
Does anybody knows what is the flow of Umbraco publishing event?
How come the large no of slibings nodes would affect the publishing performance?
Unfortunately I don't have another idea on what to try...but hopefully one of the other bright heads in here has a clue for you. This is where my knowledge is not good enough unfortunately.
Cheers, Jan
Thank you Jan for your effort.
From what I can see from the UmbracoTraceLog, it capture the node publish event almost immediately.
INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 21] Content 'XXXX' with Id '6563' has been published.
Is there any post publising event that is causing the slow down?
Anybody care to explain how Umbraco publishing work?
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Speed up Node publishing which have large no. of sibling nodes.
Hi,
Currently I have a site, where there are about 30K nodes under a node.
And publishing of content under this node takes a long time (2 mins). Is it possible to speed up the publising?
I am running version 6.1.4 of umbraco.
Thanks
Hi Domm123
That sure is a lot of nodes - I'm no database expert but perhaps you could gain some performance by adding indexes to the database?
Perhaps you can benefit from trying out the stuff that Mikkel Johansen writes about in this topic by me: http://our.umbraco.org/forum/developers/extending-umbraco/42361-This-is-a-bit-dirtybut-I-need-to-mess-with-the-database
Before you get a go at it make sure to make a backup etc.
Hope this might help.
/Jan
Hi Jan,
Thanks for your reply.
I have tried to run Mikkel Johansen script. But the performance is still the same.
I am suspecting the bottom neck to be the web server, rather than the SQL sever. (Seeing high CPU usage on w3wp).
Here are some facts:
1. Publishing of data on other nodes (which have lesser siblings) are still very fast.
2. Saving of content on the problem nodes are still fast.
3. Saving and Publising through the API for the problem nodes are very slow as well.
Does anybody knows what is the flow of Umbraco publishing event?
How come the large no of slibings nodes would affect the publishing performance?
Thanks
Hi Domm123
Unfortunately I don't have another idea on what to try...but hopefully one of the other bright heads in here has a clue for you. This is where my knowledge is not good enough unfortunately.
Cheers, Jan
Thank you Jan for your effort.
From what I can see from the UmbracoTraceLog, it capture the node publish event almost immediately.
INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 21] Content 'XXXX' with Id '6563' has been published.
Is there any post publising event that is causing the slow down?
Anybody care to explain how Umbraco publishing work?
is working on a reply...