Copied to clipboard

Flag this post as spam?

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


  • domm123 6 posts 26 karma points
    Sep 26, 2013 @ 09:07
    domm123
    0

    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

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Sep 26, 2013 @ 18:59
    Jan Skovgaard
    0

    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

  • domm123 6 posts 26 karma points
    Sep 26, 2013 @ 19:18
    domm123
    0

    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

     


  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Sep 26, 2013 @ 20:40
    Jan Skovgaard
    0

    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

  • domm123 6 posts 26 karma points
    Sep 27, 2013 @ 12:45
    domm123
    0

    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?

    Thank you
Please Sign in or register to post replies

Write your reply to:

Draft