Ken:

I'm not sure what exactly happens when transactions are involved but I have experienced the following problem on several occassions:

An index corruption caused the RI rules to fire for way, way too many records and thus seem to hange the program.

Daniel