Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • Dirk De Grave 4541 posts 6021 karma points MVP 3x admin c-trib
    Oct 02, 2014 @ 16:05
    Dirk De Grave
    0

    Lots of sql selects when opening a top level node after having copied from another top level node

    Hi,

    Experiencing high load on our sql server box when opening a top level node in backoffice. Anyone seen this before?Sql statement being executed a zillion times a minute resulting in a freeze in backoffice.

    exec sp_executesql N'SELECT id, createDate, trashed, parentId, nodeObjectType, nodeUser, level, path, sortOrder, uniqueID, text FROM umbracoNode WHERE id = @id',N'@id int',@id=-1

    Can only stop freeze by restarting sql server box, which is... hmm, not really a solution!

    Anyone any clue?

    Cheers,

    Dirk

     

    Copy Link
  • Dirk De Grave 4541 posts 6021 karma points MVP 3x admin c-trib
    Oct 03, 2014 @ 14:18
    Dirk De Grave
    100

    Found solution myself, seems one of my mntp datatypes was going into infinite loop trying to find a "start document" for the picker.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft