RE: Lock table table_name in exclusive mode - Performance gain?

2002-08-12 Thread Rachel Carmichael
Oh well, I'm delirious from a lack of sleep so the above might be a > bit > rambling. But I hope you get the idea. > > Regards, > > Larry G. Elkins > [EMAIL PROTECTED] > 214.954.1781 > > > -Original Message- > > From: [EMAIL PROTECTED] [mail

RE: Lock table table_name in exclusive mode - Performance gain?

2002-08-11 Thread Larry Elkins
lack of sleep so the above might be a bit rambling. But I hope you get the idea. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > [EMAIL PROTECTED] > Sent: Saturday, August 10,

Lock table table_name in exclusive mode - Performance gain?

2002-08-10 Thread Brian_P_MacLean
Anyone do any bench marking, know of any papers, or using "lock table table_name in exclusive mode" to get a performance boost. I'm trying to figure out how to do 90,000,000 operations (add/change/delete) on the same table/partitions in a 4 hour period, and it looks like lighting will have to str