Interesting. Thanks for running this. On the last set of tests, what if
you changed the trigger to assume the row existed and try the update
directly. If the update doesn't find the row then insert. I think you'll
save yourself an IO.

Note the last set of tests, the trigger program was "real" and designed
to
keep the "shadow" table in sync with the table being updated. The
shadow
table contains a subset of teh real tables fields. So it first checks
to
see if the record already exists in the shadow table, if so it is
updated,
if not it is inserted. In the above tests, only updates were done to
the
shadow table.

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].