The last sentence should have read " . must be set the same for all users."
Emmitt Dove Manager, DairyPak Business Systems 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 Emmitt Dove Sent: Monday, December 08, 2008 8:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Running 7.6 code from a batch? AUTOSYNC only comes into play at the time a CONNECT is issued and the database files are not in sync. QUALCOLS comes into play during multi-user UPDATEs. IF it is set to 2 AND FASTLOCK is ON AND STATICDB is ON you can see a performance improvement since R:BASE will use row locking instead of page locking. Practically speaking, this only has an impact if multiple users are attempting to update rows within the same page of data. If STATICDB and FASTLOCK are not ON, then QUALCOLS may as well be 10. STATICDB, FASTLOCK and QUALCOLS must all be set ON for all users. Emmitt Dove Manager, DairyPak Business Systems 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 [EMAIL PROTECTED] Sent: Sunday, December 07, 2008 2:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Running 7.6 code from a batch? Good suggestions. I have never run AUTOSYNC ON at my clients, so I don't know whether that slows things down. And I also don't mess with QUALCOLS, so I'll ask him if he knows why it is reduced to 2 from 10. Anyone know if that would make things slower? I've also never played around with WAIT. Boy, it looks like someone really messed with the default settings, doesn't it? This client hates seeing the "$" in the currency fields; that's why it's blank. I'd have to say that the majority of my clients also want it blank. Yes they are using the old pre-SQL defaults for character settings. They know it's a problem should they ever want to use external programs. This is by far the most complicated application I have worked on in my 22 years of RBase programming. There are thousands (yes thousands) of individual program files, haven't counted but probably almost a thousand forms and reports between 7.6 and the remaining DOS, and I had no involvement in the writing of this app so it's been pretty hard coming into this client under their contractor. Even Wrigley, a big Fortune XX-? company, does not have an RBase app as complicated as this one. It would take a Fortune 100 budget to change everything to a single quote, and this is a small privately owned company... Karen Karen, In addition to other comments I would: 1. review consequences of setting AUTOSYNC ON. The default is OFF 2. Why is currency symbol BLANK. 3. review why you SET QUALCOLS 2 -- default is 10 4. review why you SET WAIT 15 -- default is 4 sec Just an observation. Is the database really using the pre-SQL characters of DOUBLE_QUOTES=" and the SINGLE=? and MANY=* If so, while they are legal under RBase any using current help and documentation may be confused if they don't mentally make the conversion between what the documentation shows and what they actually have to enter.
