Re: would "lock table x in exclusive mode;" allow large inserts into that table to perform better/faster?

Posted in 2004

Gorazd Hribar Rajteric — Thu, 13 May 2004 21:22:41 +0200 — source: Usenet: comp.databases.informix

The most important advantage of locking table exclusively is that you will need only one lock. This is helpful if you are inserting a large number of rows (batch loads). And yes - there is some performance gain. Regards, Gorazd. "byrdfarmer" <byrdfarmer@hotmail.com> wrote in message news:5e52df43.0405130951.55294815@posting.google.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?