Even though the date range was only one day, MySQL took 114 seconds to execute. esProc transforms EXISTS operations into primary-subtable joins: ... A1 and A2 conditionally filter the primary and sub ...

SQL requires the use of MATCH_RECOGNIZE statements and multiple subqueries to indirectly implement set calculation, which is complex in code and difficult to understand.