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!
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:
This above query gets triggered round roughly once an hour
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!
is working on a reply...