RE: would "lock table x in exclusive mode;" allow large inserts i

Yes, "lock table in exclusive mode" allows large inserts to perform better (no 'lock table overflow') and really much faster. When number of locks in a session becomes significant (like 100,000), the overhead of supporting these locks requires a lot of CPU resources and considerably slows down the insert operation. ------------------------------------------ Alexey Sonkin > From: byrdfarmer@hotmail.com [mailto:byrdfarmer@hotmail.com] > > Would "lock table x in exclusive mode;" allow large inserts into that > table to perform better/faster? > > I had read in another post that doing so might speed 'updates' to a > table and I was wondering if this would translate into quicker inserts > in someway? sending to informix-list