Re: Performance issue while loading large amount of data

From: Nuno Souto <nsouto_at_optushome.com.au>
Date: 16 Jan 2003 17:40:41 -0800
Message-ID: <dd5cc559.0301161740.a3d4bfd@posting.google.com>

Ban Spam <ban-spam_at_operamail.com> wrote in message news:<Xns9304B0B91E72DSunnySD_at_68.6.19.6>...

>
> WRT to ROLLBACK in increasing amount of undo generated (generalized)

Very generalized indeed. There is no mention of indexing or any other effects (cascading constraints, etc). I'd rather not try and put this into such a tabular form. It's not *that* simple.

>
> WRT to REDO in increasing amount of redo generated (generalized)

Same here.

> So INSERT, UPDATE, & DELETE inclusive ALL generate both REDO & UNDO;
> each in varying amounts.

Yup, very much so. It's the amount of "varying" that usually causes trouble with sizing.

Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam Received on Thu Jan 16 2003 - 19:40:41 CST