Optimize network traffic and disk access

Uncategorized

We investigated the application performance. Based on analysis of profiler results following optimizations were done:

1) For CFieldValue and ItemFieldSettings entities unneeded entity refresh was skipped.
2) Fixed N+1 issue for Formula entity and found several other places where N+1 issue exists
3) Optimized CollectItemFieldSettingsByItemIds method which execution was quite expensive during scenario execution.

Those changes increased performance of the tested scenario by 45%.