Since I would need to recompile my DAT (which really isn't hard) I just placed the statements in my RFF.
-----Original Message----- From: "Emmitt Dove" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 3 Nov 2009 15:30:31 -0500 Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by changing from 2 to 10? But Mike, those need to be set prior to CONNECT. I put them in a startup .DAT file. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Tuesday, November 03, 2009 2:13 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by changing from 2 to 10? And All of these settings can avoid being overwritten by config files by setting them using ON FIRST CONNECT Run cmdFile (or RUN SELECT if you want to store them in the DB) ----- Original Message ----- From: "Emmitt Dove" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, November 03, 2009 1:48 PM Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by changing from 2 to 10? > I'll say it one more time - if you run in a multi-user environment, then > you > really should do the following, in this order, upon startup: > > > > SET MULTI ON > > SET STATICDB ON > > SET FASTLOCK ON > > SET QUALCOLS 2 > > CONNECT dbname > > > > Now, the MULTI ON can really be done anywhere before the CONNECT, but the > others need to be in sequence. > > > > Emmitt Dove > > Manager, Converting Applications Development > > Evergreen Packaging, Inc. > > [email protected] > > (203) 214-5683 m > > (203) 643-8022 o > > (203) 643-8086 f > > [email protected] > > > > From: [email protected] [mailto:[email protected]] On Behalf Of Paul > InterlockInfo > Sent: Tuesday, November 03, 2009 12:34 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by changing > from 2 to 10? > > > > From RBTI regarding Qualcols Settings "Command Index.pdf" they state the > following. > > > > Use QUALCOLS to choose page or row locking. The settings for QUALCOLS are: > > . 2 - R:BASE uses a fast row-locking method. When QUALCOLS is set to 2, > you > can lock rows of data > > instead of locking a page of data. You increase multi-user performance > when > QUALCOLS is set to 2 and > > STATICDB and FASTLOCK are on. > > . 10 - R:BASE uses page locking. When QUALCOLS is set to 10 and two or > more > users are updating rows > > within the same page of data, R:BASE only lets the first user update > rows--the other users are locked > > out until the first user's update has been completed. > > > > > > I suppose it depends on your environment. > > > > Sincerely, > > Paul D. > > > > > > > > > > > > > > > > > > From: [email protected] [mailto:[email protected]] On Behalf Of Victor > Timmons > Sent: Tuesday, November 03, 2009 11:27 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Qualcols 2 vs 10, what do you give up by changing > from 2 to 10? > > > > I just did the same thing. WOW what a difference. I hope I'm not giving > anything else up by doing this. > > > > Victor Timmons > > Tiz's Door Sales, Inc > > Visit us at www.tizdoors.com > > P Please consider the environment before printing this e-mail > > _____ > > From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. > Sinclair > Sent: Monday, November 02, 2009 3:38 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Qualcols 2 vs 10, what do you give up by changing > from > 2 to 10? > > > > Hi all, > > I just changed the setting of Qualcols from 10 (the default) to 2 and I > got > a significant improvement in my network peformance...many less pauses and > hang ups. > > > > What do I lose by changing it from 10 to 2? What was the reason for having > the default value of 10? > > > > Mike > >
