There are several things you can do to improve the performance of all CyberMatrix software:
1. install local – Install the software on every machine instead of installing it to a shared folder. It is very convenient to install software on a shared network folder. You can then run the software by placing a shortcut to the software executable. This method makes updating the software very painless. The downside is that every time someone starts the software the entire executable is copied down the network. If many people do this at the same time your network will slow down. By installing the software on everyone’s machine you prevent this slowdown.
2. archive data – Archive or delete infrequently used data. If you have a lot of old data that is no longer used you may increase performance by archiving or deleting this data. For example, if you have a long list of clients, it takes time to load all this data into pull-down lists and other queries. If you delete inactive clients or inactivate them, the loading process will be faster.
3. turn off file scanning – Configure any file scanning utilities to ignore database files. Database files change frequently. If there are any file scanning utilities like antivirus software that scans files whenever they change, this could slow down database operations. The solution is to configure the file scanner to ignore the database files or even the entire data folder.
4. use wired network – Avoid using slower wireless network connections. Despite some improvements in wireless technology, using wireless networks are still much slower than wired networks. Using a direct-wired connection will always be faster when using data intensive applications.
5. go client-server – Switch from the file-server implementation to client-server. File server applications have all the data stored in a shared folder that every client station accesses directly. When this data is accessed, entire tables are pulled through the network. For large data applications this can result in a dramatic network slowdown. A client-server application on the other hand transfers only the small data packets needed though the network instead of entire tables. As well as the Client/Server editions of our software, the Web and Enterprise editions are also forms of client/server technology.
6. no auto-refresh – Turn off the calendar auto-refresh feature or set it to a higher value like 5 minutes. Due to the complex nature of recurring schedule events, refreshing the calendar results in a lot of data access. Having an auto-refresh value that is too low can make the software unbearably sluggish.
7. closer end date – Use a schedule end date value that is not too far into the future. Checking for conflicts when adding or editing events requires a lot of data access because of the complexity of repeating events. The further in the future the software has to check, the longer a delay you will experience. By limiting the schedule to look for conflicts only into the next year, for example, this data access is reduced significantly.
You can find out more about our software products at cybermatrix.com.