At 02:20 PM 5/28/2014, [email protected] wrote:
Good afternoon: We are now working full time with eXtreme 9.5 64.
Mike, Congratulations!
Not sure if it's coincidental with other internal network issues, but my users are asking (complaining?) why the new R:BASE seems to run slower than Turbo V-8. I have reviewed the various network topics in the Help System. I don't see many appropriate options for tweaking the system. Our primary database has over 600 tables and the RX2 file is 6.4GB+ along with a ~2GB RX3 file. The database is used predominantly for ad hoc queries and studies. We might typically have anywhere from 10 to 20 users connected at a given time. It's a Windows Server network. Computers are a mix of older Windows XP machines and some newer Windows 7 32- and 64-bit machines. Any special considerations or thoughts on what can be done to improve performance?
Here's a Tip of the Day (Originally posted on May 9, 2014) Client and server computers may have one or more anti-virus, anti-malware, and/or anti-spyware utilities installed. 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, users will see much slower response times when running R:BASE, making connections, and accessing the files. When using any security-based software, it is important to add exceptions to three areas of the R:BASE program: 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". 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. Although wildcard may be accepted, adding each file extension individually as an exception may be more appropriate. 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.
Interrupting a BROWSE command: If ESCAPE is set to ON will using either the [Esc] key or Ctrl-Break work if a user is executing an especially slow-running and/or complex query through the data browser? Or does [Esc]/Ctrl-Break only work at the R> for SELECT statements?
[Esc]/Ctrl-Break combinations are more appropriate when working at the R> prompt and not using the Windows Graphical User Interface. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
