In both Freezerworks Unlimited Server versions 5.0 and 5.1, change the cache settings to improve performance.
- In the server software go to Edit – Preferences and select Database.
- Make sure there is a checkmark beside Calculation of adaptive cache.
- In the server software go to Edit – Database Settings.
- Click the Database icon.
- Switch to the Memory tab.
In both versions, set the remaining parameters as follows.
- Place a checkmark beside Calculation of adaptive cache.
- Memory to be reserved for other applications: 250MB
- Percentage of available memory used for cache: 80%
- Minimum size: 1024MB
- Maximum size: 2384MB
Quit and restart the Freezerworks Unlimited Server to activate these settings.
Tips on improving performance with Server 2003:
In Windows- System Properties ->Advance tab -> Settings (under Performance) set the following:
- Windows Processor Scheduling: “programs” instead of “background processes”
- Windows Memory: set to “programs” instead of “system cache”
- Windows Page File: set to “System Managed Size” instead of “Custom Size”
MS introduced a system designed to prevent DOS attacks on win server 2003. But this can cause issues with 4D other SQL databases. There are two work-arounds, see: http://kb.4d.com/search/assetid=76127
- The connection has been reset by the remote host.
- TCP_PROV: An existing connection was forcibly closed by the remote host.
- “ProviderNum: 7, Error: 10054, ErrorMessage: “TCP Provider: An existing connection was forcibly closed by the remote host …”
- Unhandled Exception: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.)
Tips for improving performance with Windows 2008 Server:
Should only be using the R2 release. There is a problem in Server 2008 (not R2) that causes the OS to cache application data like 4D’s to disk even when there is plenty of RAM. This kills performance. This is fixed in R2. See http://support.microsoft.com/kb/976618
Set the server to “Application Server” role using the Add Roles wizard.
(Freezerworks Unlimited version 5.0 and later)
You have the ability to index User Defined Fields (UDF). It is a good idea to index any of your UDF’s that you search on regularly. To index a UDF:
Select System Admin > User Defined Fields. Double click on a field that you search by regularly.
Notice the area for Indexing. There are two options when indexing a UDF: Many Duplicate Values and Many Distinct Values. This depends on the kind of field that you are indexing.
-Many distinct values – check here if the field tends to be unique to the sample or aliquot record (e.g., Patient Identifier’s, Sample IDs, Aliquot IDs, etc.).*
-Many duplicate values- check here if the data in this field tends to be shared among many records (e.g., specimen types, aliquot types, site, etc.).
Depending on how many records you have in Freezerworks, when you save the UDF, it may take a few moments to index.
*Note that fields marked as Unique will have the Index Field checked ON automatically, set to “Many distinct values.”