I have a copy of this FTE article already stored, so I'll have to look through it. It appears that a switch to Windows 7 must mess something up, some setting that wasn't required while on XP...
Karen -----Original Message----- From: jan johansen <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, Dec 3, 2012 1:57 pm Subject: [RBASE-L] - Re: Slow database, 7.6 From an email from Razzak on Sep 26: From the Edge: R:BASE Multi-User Guide Section: Multi-User, Configuration, Speed Versions: R:BASE eXtreme 9.5 (32/64) for Windows R:BASE eXtreme 9.1 (32/64) for Windows In a multi-user environment R:BASE allows users to simultaneously access, view, update, insert, and delete data. To most efficiently use R:BASE on a network, R:BASE uses various types of settings, locks and a waiting period to avoid situations that cause R:BASE to work more at preventing user conflicts than at storing, sorting, and retrieving data. Chapters also include guidelines to increase performance of applications through command syntax and forms. From The Edge: http://www.razzak.com/fte/ Topic: R:BASE Multi-User Guide Jan -----Original Message----- From: Karen Tellef <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 3 Dec 2012 14:29:49 -0500 (EST) Subject: [RBASE-L] - Re: Slow database, 7.6 I checked on the server. It already had "row locks" checked, and "column verify". Got excited for a second when I saw your post, but it looks okay. Wait time 4, wait interval 5, autorefresh level 0. Would this be only on the server, or do I need to have every workstation checked? I do not make active use of a configuration file and I've never looked at it. Thanks for the suggestions! Karen -----Original Message----- From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Mon, Dec 3, 2012 12:45 pm Subject: [RBASE-L] - Re: Slow database, 7.6 Karen - check the configuration file and make sure data is set to columns. In the main window, * Settings > Configuration Settings > Multi * Check mark Row Locks * Set to column verification, not row verify See if that helps. Albert On 03/12/2012 10:33 AM, Karen Tellef wrote: > I have a remote client still on 7.6 windows. A while back they got a > couple new computers with 32-bit windows 7. Apparently since then > they've been having problems but didn't tell me. Theyjust now > replaced a server thinking it would fix the problem and it hasn't. > > I dialed into the guy's computer and I see what's happening. In the > sales module, the program inserts rows into a detail table > (BladingDet) and then brings up a form to edit the data. Sometimes > the program hangs when trying to insert, eventually comes back with my > program's error message that it failed to insert the rows. Othertimes > it eventually is able to insert the rows, but on the edit form it can > take 30 seconds to change one field on a row and try to go to the next > row. During that delay, the main menu form often pops up in front so > they have to get it out of the way. > > It never happens when only one person is connected. As soon as the > second is connected all this slowness and failing happens. Autocheck > was okay, and I did a reload. Do you think an "unload" is in order? > What else could cause this incredible slowness and failing? I'm not > a network or hardware expert so I'm at a loss at knowing what > "settings" should be looked at. > > Gosh, I HATE problems like this.... > > Karen > > No virus found in this message. > Checked by AVG - www.avg.com <http://www.avg.com> > Version: 2013.0.2793 / Virus Database: 2634/5930 - Release Date: 12/01/12 >
