Access to Freezerworks over the network is slow. What can I do to improve performance?

Freezerworks Server and Client may cause spikes in, or a constant elevation of, CPU Usage. In Freezerworks Server, go to Edit – Preferences and highlight Application-Client/Server. In the Client/Server Communication section, remove the checkmark in the “Register Clients at Startup For Execute On Client” box. Quit Freezerworks Server, and then restart Freezerworks Server. CPU Usage should idle at <10%. Upon Freezerworks Client connection, usage may rise as high as 50-60% during intense processing routines (e.g., Import Samples and Searches).

(Windows and MacOS9) For versions earlier than Freezerworks Unlimited 3.1 and Freezerworks Basic 6.0: If Client/Server performance seems slow, check the application memory setting on the server. Select Edit-Preferences in the Freezerworks Server window. Click the Application icon on the left. Confirm the Application Main Memory is set to at least 4 blocks of 32768 kb. Increase the number of blocks to dedicate more RAM to the Freezerworks Server application.

Another idea to improve performance is to increase the Cache Size. See the section Database Cache Memory in the System Administrors Guide.

Poor performance using Windows Server 2000, 2003:

Windows Server 2000 and 2003 can be configured for use as a file server, which means it will try to allocate as much memory as possible to the file system cache.

Since 4D has its own cache that it manages for itself, you can end up with “dueling caches” which can cause very slow performance, especially after doing things like a full system backup. During the backup (and depending on the backup software you use), Windows may be caching every file as it gets read, which will force 4D’s cache into virtual memory. You’ll have to restart 4D Server or perhaps even reboot the box to get its cache out of the swap file and regain good performance from 4D Server.

So the solution is to tell Windows not to aggressively cache the file system. Here’s how to do it in Windows Server 2003:

  1. Right click on My Computer and select Properties.
  2. Click on the Advanced tab
  3. In the Performance panel, click Settings
  4. In the Performance Options dialog, click to the Advanced tab
  5. In the Memory Usage panel, change System Cache to Programs (or Applications).
  6. And as long as you’re in this dialog, note the Processor Scheduling panel directly above the Memory Usage panel. If you’re running 4D Server as a service, mark the option to favor Background Services. If you’re not running 4D as a service, mark the option to favor Programs (or Applications).