create a new transaction for each delete chunk
delete operation does not support limit. limit on select and delete afterwards