Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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
Hi Michael,
Do you have some performance issue on yiur site?
You can use Miniprofiler for checking stuff like that.
Thanks,
Alex
Are you by any chance using the content service API in your code?
I found solution for my issue.
delete from SEOChecker_URLHistory where nodeid not in (select id from umbraconode)
~187 records.
Great Michael, so we have to be aware when using SEOChecker.
Thanks
is working on a reply...
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.
Continue discussion
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
Hi Michael,
Do you have some performance issue on yiur site?
You can use Miniprofiler for checking stuff like that.
Thanks,
Alex
Are you by any chance using the content service API in your code?
Hi all,
I found solution for my issue.
delete from SEOChecker_URLHistory where nodeid not in (select id from umbraconode)
~187 records.
Thanks, Mike
Great Michael, so we have to be aware when using SEOChecker.
Thanks
is working on a reply...
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.