John,
Duh! I never thought to add the scratch files to the exception. Thx -----Original Message----- From: John Minyo II <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 10 Jul 2012 14:37:09 -0400 Subject: [RBASE-L] - Re: Speeding up the CONNECT (and SCONNECT) command, etc. At 09:31 PM 7/9/2012, Michael J. Sinclair wrote: >What can I do to speed up the time it takes for Rbase 9.5 32 to complete >a connect, or disconnect or sconnect command? I have the number of files >in the database directory down to 8 including the 4 .rb? files. The >database is pretty big, the .rb2 file is about 1.8 gig. When I trace my >code looking for speed enhancements, it seems that the slowest commands >are connect, sconnect and disconnect. How long should those commands >take to complete? I guess I am used Rbase for DOS where the times are >nearly instant. At 02:05 PM 7/10/2012, [email protected] wrote: >Don't have an answer.. With my latest 9.5 client we wanted to go to >an external file as the startup, and do a connect/disconnect at every >menu to avoid hung connections at backup time. But it takes so long >to do each command (probably 10 seconds) that we were asked to >drop it. We have just the 4 DB files, 1 startup program and the 1 EFF >in our testing environment. So it wasn't the number of files. On a >standalone environment, it still took probably 7 seconds, so a little >better but still pretty slow. At 02:12 PM 7/10/2012, Jan Johansen wrote: >I had also originally done your suggestion but the time was killing us. >If we could get Windows 7 and Server 2008 to not be so aggressive >with security it might help. > Michael, Karen, Jan, et al: Client and server computers will have one or more of anti-virus, anti- malware, and anti-spyware installed. When using any security-based software, it is important to add exceptions to three areas of the R:BASE program: 01. The R:BASE program executable For R:BASE eXtreme 9.5 (32), the executable name is RBG95_32.exe. The default folder where it is installed is "C:\RBTI\RBG95_32". For R:BASE eXtreme 9.5 (64), the executable name is RBG95_64.exe. The default folder where it is installed is "C:\RBTI\RBG95_64". 02. The Database files For R:BASE eXtreme 9.5 (32), the database files are the four .RB1, .RB2, .RB3, and .RB4 files. For R:BASE eXtreme 9.5 (64), the database files are the four .RX1, .RX2, .RX3, and .RX4 files. Add each file extension as an exception. 03. The Temporary Scratch Files When R:BASE is launched, it will create three .$$$ temporary files. After performing certain actions, additional files may be created, and the existing files will increase and decrease in size. Add the *.$$$ files as an exception. If R:BASE itself is scanned each time it is launched, and the contents of the database and temporary files are halted and scanned each time they are created/accessed, you will see much slower speeds when running R:BASE, making connections, and accessing the files. Best regards, John Minyo II Customer Service R:BASE Technologies, Inc. P: 1+724.733.0053 http://www.rbase.com http://www.facebook.com/rbase
