Question

A synchronous plug-in registered on the Update message of the Account table must read data from up to 500 related Contact records to recalculate an aggregate field. During load testing, the plug-in causes noticeable latency and occasional timeouts. The developer uses IOrganizationService.RetrieveMultiple with a QueryExpression. Which change to the query will MOST improve the plug-in's performance?

Accepted Answer

Set ColumnSet to only the specific columns required for the calculation instead of ColumnSet(true).

Answer

Wrap each Contact retrieval in a separate Retrieve call inside a loop to reduce the size of each request.

Answer

Set the query's NoLock property to false to ensure transactional consistency during the read.

Answer

Move the query into a PreValidation stage so it executes outside the database transaction.