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


  • Michael 125 posts 409 karma points
    Jul 14, 2016 @ 10:39
    Michael
    0

    Umbraco node table access

    Hi all,

    Who can help me with my issue.

    SELECT DISTINCT id FROM umbracoNode WHERE (path LIKE @nodeId )

    lots around 23,181 times an hour

    and sometimes more: ~40-45k per hour.

    Which method produce this query?

    Thanks, Mike

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Jul 20, 2016 @ 14:22
    Alex Skrypnyk
    0

    Hi Michael,

    Do you have some performance issue on yiur site?

    You can use Miniprofiler for checking stuff like that.

    Thanks,

    Alex

    Copy Link
  • Greg Fyans 140 posts 342 karma points
    Jul 20, 2016 @ 15:03
    Greg Fyans
    0

    Are you by any chance using the content service API in your code?

    Copy Link
  • Michael 125 posts 409 karma points
    Jul 21, 2016 @ 06:27
    Michael
    100

    Hi all,

    I found solution for my issue.

    delete from SEOChecker_URLHistory where nodeid not in (select id from umbraconode)

    ~187 records.

    Thanks, Mike

    Copy Link
  • Alex Skrypnyk 6182 posts 24283 karma points MVP 8x admin c-trib
    Jul 21, 2016 @ 11:30
    Alex Skrypnyk
    0

    Great Michael, so we have to be aware when using SEOChecker.

    Thanks

    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