How to reduce query execution time with LOGIC filter?

Question

1C-Bitrix

Hello.

There is a component in which getList is executed with a LOGIC filter. Is it possible in this case to somehow change the filter for faster execution?

$arFilter = array(
      "IBLOCK_ID" => 1,
      array(
        "LOGIC" => "OR",
        array("PROPERTY_actors" => $arResult["ID"]),
        array("PROPERTY_actorsMain" => $arResult["ID"]),
        array("PROPERTY_writer" => $arResult["ID"]),
        array("PROPERTY_director" => $arResult["ID"]),
      ),
    );

    $rsElement = CIBlockElement::GetList(Array("PROPERTY_dateStart" => "DESC"), $arFilter, false, Array(), $arSelect);

I guess it's because of multiple JOINs:

LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='ACTORS'

Answer 1

Disabling sorting and select did not help. Only the restructuring of the sampling logic helped. Added a separate field that included all the elements for which the filter was true. The sample earned ~10 times faster.

Answer 2

Most likely it's not about joins, but about filtering and sorting.
To optimize the query, try temporarily removing the sort and the $arSelect array and see if there are any changes.
It is also worth finding out if there are indexes in MySQL.
Bitrix admin panel has a page with information about indexes.
You can also try to transfer the infoblock data to a separate table (this option is available in the infoblock settings) and look at the indexes in the new table with the infoblock and if they are not there, create them yourself.