deleting records with DBouput

oldforum

• July 16, 2007 00:00

• Answered

Follow

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

• 

  oldforum

  • July 16, 2007 08:23

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.