Deleting records with DBouput

CloverDX Platform
1

I am trying to delete records in a DBtable using the DBoutputTable. i create the node using
Node deleteAllChanges = new DBOutputTable(“DeleteAllChanges”,“stage”, “delete from PersonalIdentifiers where person_pidm = ?”, new String {“person_pidm”});

The edge connected to this only has the person_pidm field but the table it is deleting from has 5 or so others. when i run this this node does not seem to do anything

2

well i found out that it was working but only at a few record per second and so it takes along time. is there a faster way to delete 1000 or so records. the keys of the records to be deleted are coming from a clover data file