Copied to clipboard

Flag this post as spam?

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


  • Andy1993 1 post 21 karma points
    17 days ago
    Andy1993
    0

    Locating ''[umbracoPropertyData] WHERE ([umbracoPropertyData].[versionId].." query

    I have recently noticed that there are two long running query which gets triggered in our system that's contributing to database spike:

    (@1999 int,@1998 int,@1997 int,@1996 int,@1995 int,@1994 int,@1993.....@1) 
    Delete FROM [umbracoPropertyData] WHERE ([umbracoPropertyData].[versionId] IN (@0, @1....,@1999))  
    

    This above query gets triggered round roughly once an hour

    (@1999 int,@1998 int,@int.......... @6 int,@5 int,@4 int,@3 int,@2 int,@1 int,@0 int) 
    SELECT [umbracoPropertyData].[id] AS [Id], [umbracoPropertyData].[versionId] AS [VersionId], [umbracoPropertyData].[propertyTypeId] AS [PropertyTypeId], [umbracoPropertyData].[languageId] AS [LanguageId], [umbracoPropertyData].[segment] AS [Segment], [umbracoPropertyData].[intValue] AS [IntegerValue], [umbracoPropertyData].[decimalValue] AS [DecimalValue], [umbracoPropertyData].[dateValue] AS [DateValue], [umbracoPropertyData].[varcharValue] AS [VarcharValue], [umbracoPropertyData].[textValue] AS [TextValue]
    FROM [umbracoPropertyData] WHERE ([umbracoPropertyData].[versionId] IN (@0,@1,@2,@3,.......... @1998,@1999))
    

    This above query gets triggered roughly 10 times every now and then

    I am not too sure where these queries were coming from and why they are being triggered. Could anyone give me a hand? We are using umbraco 10 with dgte. Any help will be much apprecaited!

Please Sign in or register to post replies

Write your reply to:

Draft