On Nov 24, Jeff Urlwin scribed:
> >
> > I do what you originally did ($dbh->do("delete...") all the
> > time on Oracle 8.1.7. The only difference I have is
> >
> > my $dbh = DBI->connect("dbi:Oracle:database", "user", "pass",
> > { RaiseError => 1, AutoCommit => 0 });
> >
> > i.e. I explicitly set AutoCommit off. I always have done
> > that, and don't know what the default is. It sounds like
> > AutoCommit is on. 42K commits wouldn't be very pretty, but I
> > would expect that some of the rows would have been deleted.
> > Have you tried trace()?
>
> Hold it. This needs to be clear...
>
> If you have AutoCommit on and one delete statement that deletes 42,000 rows,
> that's no
> different than without AutoCommit and one commit after the statement.
> AutoCommit would
> *not* commit after each row is deleted in a single statement. It commits
> after the
> statement is complete.
>
> Jeff
>
>
Of course, you are correct. I don't know what I was thinking when I wrote
that.
Dave
