Razzak-
Will the same settings be good for INSERT INTO ... VALUES/SELECT as well? Rommel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of A. Razzak Memon Sent: Friday, September 28, 2001 4:27 PM To: [EMAIL PROTECTED] Subject: Re: QUALCOLS - Razzak's Reply At 03:59 PM 9/28/2001 -0700, Frank Radice wrote: >... I am looking through my code to see if there are other >similar indexing problems ... Frank, The FASTEST method for updating data in multi-user mode is: SET STATICDB ON SET FASTLOCK ON SET QUALCOLS 2 Above group of settings results in the fewest contentions between users. SET QUALCOLS 10 to make use of page locking, especially when you are doing an UPDATE or DELETE affecting many rows in a table. FYI, QUALCOLS can be changed during an application and can be different for different users of the same database. Very Best Regards, Razzak. ===================================-============================ R:BASE Developers's Conference: http://www.rbase.com/conference Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-=============================
