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

Posted in 2004

Topics: Transactions, Locking & Isolation

brett — Mon, 17 May 2004 10:23:12 +1000 — source: Usenet: comp.databases.informix

Locking in excusive mode will just stop users accessing the table. It may have a very marginal increase in the insert/load speed.. The best way to speed up a large insert/load is to remove the indexes and then recreate them once the insert/load is finished. "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?

↪ replying to brett

Paul Watson — Mon, 17 May 2004 08:20:56 +0100 — source: Usenet: comp.databases.informix

If you are happy to drop the indexes then I'd make the table raw for the duration of the load brett wrote: > > Locking in excusive mode will just stop users accessing the table. It may > have a very marginal increase in the insert/load speed.. > > The best way to speed up a large insert/load is to remove the indexes and > then recreate them once the insert/load is finished. > > "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? -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #