On Premises Performance Settings


To clearly state the purpose of the Configuration Requirement:

1.    A guide that can be given to the customers IT guy for awareness and information 

2.    A guide that our technicians can use in troubleshooting on a recurring problem

3.    Ensures all important points are not missed


Server:

1. Set to static IP address

2. Time out setting is enabled : "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters : Value name: KeepAliveTime type: REG_DWORD data : value is 180000

3. Power Save set to High Performance

4. NIC Power Saver : Disabled Control Panel\Network and Internet\Network Connections

5. Exempt pervasive ports on firewall – ports 3351 and 1583

6. Exempt systemfive.exe and  w3dbsmgr.exe (System5 and Pervasive executable) on any security software

7. Shared folder : Read and Write access for Users/Systems/Administrators credential

8. Pervasive Workgroup or Server engine must be installed

9. In some cases disabling TCPIP V6 has offered some performance increases


Client:

1. NIC Power Saver: Disabled Control Panel\Network and Internet\Network Connections

2. Power Save set to High Performance

3. Map drive – Map via hostname /reconnect at log on option is enabled / configure login.bat if necessary set to persistent as Y

4. Exempt pervasive ports on firewall – ports 3351 and 1583

5. Enabled NetBIOS

6. Disabled IPV6 

7. Exempt systemfive.exe and  w3dbsmgr.exe(System5 and Pervasive executable) on any security software

8. Pervasive client engine should be installed unless station is a standalone LAN computer

9. Client ODBC driver is installed/activated on windows (these are stations that at log on we see DSN errors besides “DSN is invalid”)

10. Must run wired connection and not wireless

11. In some cases disabling TCPIP V6 has offered some performance increases

12. Also check the Windows User Account Control Setting, this is one of the reason why System Five is slow at the start when you run but when you are already In, it is not slow anymore. So it's up to the customer if they will agree to change the User Account Control to "Never notify".