Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • pnr 131 posts 226 karma points
    Nov 22, 2017 @ 13:40
    pnr
    0

    Very slow save function

    We have a umbraco site with many nodes (30.000+). When saving nodes, it can take up to an hour, before the node is saved. Anyone having an ideer of what the problem can be?

    It is version 7.6.3

    Copy Link
  • Alex Skrypnyk 6182 posts 24284 karma points MVP 8x admin c-trib
    Nov 22, 2017 @ 15:19
    Alex Skrypnyk
    0

    Hi pnr

    Lets try to find out what is the problem.

    Are you using MSSQL or SQLCE?

    What hosting are you using?

    Can you check /App_Data/Logs - are there some errors in the log?

    Do you have access to source code of the project? Can you check - do you have some events running during node creation?

    What about page load speed, is it ok?

    Thanks

    Alex

    Copy Link
  • pnr 131 posts 226 karma points
    Nov 23, 2017 @ 10:30
    pnr
    0

    Hi Alex

    Thanks very much for your reply!

    We are using MS SQL

    We are hosting the solution on a Windows server 2012 R2

    No errors are logged in "app_data/Logs/

    There should be no event running during node creation

    Page load speed is ok

    I have checked the table cmsContentVersion at it contains 178.000 rows, I don't know if that can be the issue?

    When I press save the Database is using a lot CPU, going from about 5% to 50-60%

    I

    Copy Link
  • Matthew Wise 271 posts 1373 karma points MVP 5x c-trib
    Nov 23, 2017 @ 12:52
    Matthew Wise
    0

    Hi pnr,

    It could well be the version table slowing you down, you can remove them using UnVersion obviously backup before you try it etc etc.

    Matt

    Copy Link
  • Alex Skrypnyk 6182 posts 24284 karma points MVP 8x admin c-trib
    Nov 23, 2017 @ 12:59
    Alex Skrypnyk
    0

    HI PNR

    We cleaned sites a lot of times with unVersion it really works

    Copy Link
  • pnr 131 posts 226 karma points
    Nov 28, 2017 @ 10:37
    pnr
    0

    Hi Matthew and Alex

    Thanks very much for your replies :-)

    I have tried installing UnVersion and have setup the file unversion.config, but it is not deleting any history:

    The page with the DocType FrontPage has a lot of history.

    Thanks very much in advance :-)

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies