Re: Delete statement consuming more resource

DELETE ALL is fast if it's the last statement within a transaction and the optimizer knows it will be commited (no transient journal).

INS/SEL is fast if the target table is empty at the begin of the transaction (no transient journal).

Now a macro is exactly the same as a multi-statement request, both DELETE and INS/SEL are part of a single transaction. DELETE is not the last statement, INS/SEL is not in an empty table, so both are journaled (= slow).