Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

Stored procedure netActivityLogEntrySave performance tuning

Fixed in

EPiServer.CMS.Core 10.8.0

(Or a related package)

Created

Mar 24, 2017

Updated

Nov 28, 2017

Area

CMS Core

State

Closed, Fixed and tested


Description

SP reported to run slowly in customer environment (100ms), when looking at TSQL it seems unnecessary that the MERGE statements for tblActivityLogAssociation runs for inserts and it would be faster to just insert the data directly in this scenario. Especially if this table grows large.

Since activity logs are stored asynchronously this tuning is probably not having any affect on site performance but might make the stored procedure run faster when monitoring database traffic.