On Tue, 28 Oct 2003, Ati Rosselet wrote:
> I have several tables with common FKs.. the problem occurs when
> performing a large number of inserts on any of the tables at the same
> time. The first to start inserting seems to get a lock on the
> referenced FK tables and doesn't release them until
I have several tables with common FKs.. the problem occurs when
performing a large number of inserts on any of the tables at the same
time. The first to start inserting seems to get a lock on the
referenced FK tables and doesn't release them until its done, forcing
the other apps to just wait... a