Optimize complex list property update (no DELETE + INSERT)

Updating a complex list property triggers DELETE and INSERT SQL statements.
This could be optimized using UPDATE statements (DELETE is quite costly because of the ON DELETE CASCADE option).
Attached stack trace of such a call.

In addition to being costly, on Microsoft SQL Server this may cause deadlocks, see the next comment.