How to bulk update directories?

Question

1C-Bitrix

There is an HL-block directory in which you need to fill in more than 200K records, checking whether they already exist or not.
How can such a problem be solved?

sequential use of $entity_data_class::getList, then add one by one is a very bad approach ((
If you use sql directly, then INSERT INTO allows you to add several records at once. Is there a possibility for api? or if I update not through api, but through sql what could be the problem?

Answer 1

We search for duplicates with one request, filter the source array based on the received duplicates, do add