Hi Alew, In log message it is SELECT not DELETE, which is strange to me.
As far as I understand Ignite will execute it this way: Reducer (a server node which is responsible for executing the statement) asks mappers (all other server nodes) for all entries, which satisfy this condition AccountId = 1001. Mappers find entries are transfer them to reducer. After that reducer merges the result and picks 2000 entries then sends jobs to mappers to delete these entries on all server nodes. You can rewrite you query this way: DELETE FROM IgniteTransfer WHERE AccountId = ? AND TimeStamp < ? then it will be executed in one step and perform much faster, but you need to pick a particular date in this case. Best regards, Maxim. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
