Bulk insert/upsert cross referenced system notes

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

Summary

When a commit description contains a reference to commit/merge request/issue, a cross-reference system note is created. Even though the number of references is limited, it still requires a lot of SQL request to create a reference one-by-one:

• One SQL request is performed for each reference in order to check its existence: cross_reference_exists?.
• N requests per reference are performed in order to create a reference.

Potential solution

We should consider bulk inserting/upserting the system notes instead.