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
