Deprecated: Array and string offset access syntax with curly braces is deprecated in /homepages/12/d802028692/htdocs/forum/Sources/Subs.php on line 3863
How do I install the database on a Local Area Network (LAN)?

Author Topic: How do I install the database on a Local Area Network (LAN)?  (Read 5381 times)

Rick Leffler

  • Administrator
  • Sr. Member
  • *****
  • Posts: 327
    • Approved Workman
How do I install the database on a Local Area Network (LAN)?
« on: August 08, 2008, 10:39:57 PM »
We now have a web-based database that is a great solution for those needing access for multiple people and/or from multiple locations.  Visit our website for more information: http://www.approvedworkman.com/awdb/cloud-database.

Here are recommendations for installing and running the Approved Workman Database on a Local Area Network in a multi-user scenario:

Note: Some wireless network connections may be too slow for adequate database performance, therefore a WIRED network connection is recommended.

1.   Only have a single installation of the Approved Workman database on the server (or a PC acting as the "server").  You can easily move the "Approved Workman" folder (which will include the ApprovedWorkman.exe file and the DATA subfolder) from any other PC currently running THE copy of AWdb to the shared location on the server, you don't actually have to "install" anything.
2.   Share the "Approved Workman" folder and all subfolders (specifically the DATA subfolder) and set security permissions to "Full Modify" for all users/workstations that will have access to the database.
3.   Do NOT install or have any other AW software on any of the workstations. Just create a shortcut on the workstation that points to the ApprovedWorkman.exe  located in the ..\Approved Workman folder of the server.
4.   From each workstation launch the exe via the shortcut, if you get a message the first time about not locating the data, this is normal, just click ok and then use the folder browse dialog that will appear to navigate to and select the DATA folder on the server.  Note: You MUST keep the relative folder names of "Approved Workman", with its "Data" subfolder.  Thus " ..\Approved Workman\Data"   is expected.  UNC paths are acceptable, you do not have to map a drive letter.
5.   From each workstation, go to Admin > Database Utilities > Database Configuration  and triple the default values on that dialog.
6.   Do not share user names and passwords, make sure EACH person has a unique name and password to log into AWdb.
7.   To significantly improve performance when saving Member records, turn off the automatic refresh of the Clubber List of each workstation. To do this, click on the Grid Options (looks like a gear) and uncheck  "Automatically refresh...".  Naturally users will then have to manually click the refresh button when needed.
8.   Make sure any anti-virus software is NOT scanning the Approved Workman folder or its Data subfolder.
9.   Performance may be increased by turning off the opportunistic locking by editing the Registry of the server PC. If this becomes necessary, see the section below named "Opportunistic Locking".

Rick Leffler
Leffler Systems

- - - - - - - -
 
Performance Tuning on a networked multi-user installation of the Approved Workman database:
Please forward this information to your network administrator so he/she may decide if it is applicable:
 
If you are running the database over a network and have more than one user logged in concurrently, you may want to use the following information to improve performance.  Try running the database first without making any of the following changes.
 
On the PC acting as the Server: (assuming Microsoft Windows XP or Vista as the O/S), you can increase performance by:
 
A: Enable Write Caching by doing the following:

1. Access My Computer;
2. Access Local Disk (c:) properties (right-click and select Properties);
3. Select Hardware;
4. Select the hard disk and click properties;
5. Select Disk Properties (might be also named Policies);
6. Enable Write Caching and Enable advanced performance.
7. Click OK.
8. Shutdown and restart the Server PC.

B: Use the Database Configuration Utility on each workstationby doing the following:

1. Log into AWdb and open the Database Configuration utility found under Admin > Database Tools > Database Configuration. 
2. Adjust the following two settings by clicking the up arrow of the spin edit component:
    Total amount of memory to use for record buffers per physical table:         98304
    Total amount of memory to use for index page buffers per physical table:  98304
    Click OK, then exit and restart the Approved Workman database.
 
Opportunistic Locking:

C: Make the following Registry Changes
    (Add the key if it doesn't exist)
<<WARNING : Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. So, don't do this if you are not comfortable editing the Registry. >>
The following Registry settings should be configured on ALL PCs:
 
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRXSmb\Parameters\
The OplocksDisabled registry value configures Windows clients to either request or not request opportunistic locks on a remote file. We want to prevent a workstation from requesting the lock so the value should be set to 1.
OplocksDisabled REG_DWORD 0 or 1   Default: 0 (not disabled)    Set this value to 1 to disable it.
----------------------------
 
On the 'Server' PC add the following registry key:
 
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
The EnableOplocks value configures Windows-based servers (including Workstations sharing files) to allow or deny opportunistic locks on local files.
 
EnableOplocks REG_DWORD 0 or 1  Default: 1 (Enabled by Default)   Set this value to 0 to disable it.
You can deny the granting of opportunistic locks on the server PC by setting the following registry entry to 0:
Reboot each PC that had a Registry change, make sure to reboot your Server PC and have it running first.
 
----------------------------


« Last Edit: January 28, 2021, 02:51:23 PM by Annette »
Rick at Leffler Systems
Murfreesboro, Tennessee