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

  • Alex Skrypnyk 6131 posts 23950 karma points MVP 7x 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

  • 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?

  • 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

  • Alex Skrypnyk 6131 posts 23950 karma points MVP 7x admin c-trib
    Jul 21, 2016 @ 11:30
    Alex Skrypnyk
    0

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

    Thanks

Please Sign in or register to post replies

Write your reply to:

Draft