Rommel,
TTBOMK, the QUALCOLS setting mainly affects UPDATEs or DELETEs. Personally, I don't know the affects on INSERT INTO ... VALUE/SELECT. Please try and see what happens. Your feedback will be greatly appreciated. Meanwhile, use SET QUALCOLS 2 if_you_know that your application mainly updates or deletes data a_row_at_a_time, rather than many_rows_at_a_time. Very Best Regards, Razzak. At 04:58 PM 9/28/01 -0700, Rommel Relosa wrote: > >Will the same settings be good for INSERT INTO ... VALUES/SELECT as well? > > -----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. >==================================-=============================
