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
    Feb 04, 2025 @ 18:00
    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!

  • 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