On May 11, 2:36 pm, Serge Rielau <srie...@[EMAIL PROTECTED]
> wrote:
> JohnO wrote:
> > The deletes are only going to be purge/archive operations, rather than
> > business transactions. The first one is going to delete the millions
> > as it will be several years worth. Subsequent ones will be annual so
> > will still be pretty big, but not quite so bad.
>
> If that's the case why don't you use batch process. Triggers are meant
> to to be active database objects. I wouldn't use them for maintenance
tasks.
>
H Serge,
Speed, mostly. This is a JDEdwards OneWorld site, so any batch work
will be written in the OneWorld toolset, and will likely end up bing
millions of individual inserts and deletes. The process would take
many days for some of the files.
It's so much faster to do a bulk delete, and I was hoping the trigger
would optimise out well enough.
The statement based trigger seems to be the most efficient, but with
the problems I pointed otu at the start.
Cheers,
JohnO
|
