Re: DELETE FROM - Somethings not right

Wow.

Something is weird here.

I wonder if the delete is doing each row as an individual transaction,
with commit.

How could this be????

Perhaps it is deleting a row, rebuilding the index, committing, moving
on to the next????

A delete on 33k rows should be like 3 seconds.

????????????????

.

Relevant Pages

  • Re: large delete
    ... after which we execute immediate a delete statement. ... end loop; ... do NOT commit every n records. ... and find where people ask about deleting millions of rows, ...
    (comp.databases.oracle.server)
  • "create or replace" for dbms_job
    ... first for the old version of the procedure, and then deleting it. ... an air of 'DDL' about it; why should it be necessary to commit ...
    (comp.databases.oracle.misc)
  • RE: problem adding child records
    ... How are you adding the parent row? ... commit the row to the DataTable by moving to another row, ... calling the EndEdit method on the CurrencyManager. ...
    (microsoft.public.dotnet.framework.adonet)
  • [patch 33/38] SCSI: gdth: scan for scsi devices
    ... 2.6.24-stable review patch. ... If anyone has any objections, ... commit: 61c92814dc324b541391757062ff02fbf3b08086 ... missed one simple fact when moving a way from scsi_module.c. ...
    (Linux-Kernel)
  • Re: Theories of lead and follow
    ... proportionally progressive - you commit more and more as more and more ... example, in foxtrot, once moving she has to keep moving and modify the ... but I don't think the predictions falls off a ... before you lead the exact step size, ...
    (rec.arts.dance)