support commit transaction per fetch while iterate