Hi All,

Currently in the application we have an action which is used to anonimyze personal data in the database. This action is placed in a service action and is called from an external system. 

The action goes like this:

1. Via an aggregate retrieve the specific records

2. Loop through them via a for each loop

3. Assign the "" to fields like name etc.

4. Assign the emptied record to a local variable of the same structure

5. Update the record with the Current record from the aggregate (update entity action)

6. Log the changes

7. Assign the number of rows affected + 1

The update entity action for 1 record takes as specified in the title 11596 ms to complete, which logs it as a slow sql and is probably the cause of the timeout that terminates the action; "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated". Eventually the record does show to be updated in the database.

Any ideas what may cause an update entity action to take so long and any ideas how to fix this?