> If you disable idx2, you will see that the inserts go much faster. I
> also observe that the journal file is about 1/3rd the size of the database,
> which is consistent with the observation that every disk block associated
> with idx2 needs to be changed. My TCL test script for this situation
> is appended to this message.
> [...]
> Can any readers suggest ways that I have not thought of for making
> large numbers of non-localized INSERTs go faster?
I don't know what you've thought of ;-) but here're some things to
consider...
Instead of journaling the old ("undo") pages of idx2, simply record
the fact that idx2 is modified (i.e., make a single record in the
journal). Upon recovery, noticing that idx2 is modified will cause it
to be recreated from the rolled-back data.
Of course, this will make transaction rollback slow. If that is a
concern, the journal could record just the keys that were added and
removed from the index, and a rollback (or recovery) could remove and
restore those keys, respectively.
e
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
