RE: Native Delete vs. SQL

From: Walden H. Leverich

I could perform READE on the files and delete Records, but would
performance be better or worse if I ran the deletes via SQL

This is one of those cases where I don't even think Joe would
disagree... Deleting a "set" of records from a table based on key is
always going to be faster in SQL than in a loop with READE/DELETE.

I tend to agree, as long as the number of records is a certain number > 1.
I still don't think an SQL DELETE of a single record is as fast as a DELETE
by key.

Note that I don't use READE/DELETE in this situation, I use DELETE with a
key list.  It doesn't have to (AFAIK) read the data into the RPG buffers and
so is very fast.

The commitment control question is an interesting one, and at that point it
REALLY depends on a lot of factors such as workload and transaction size and
lots of other goodies.

Joe