Caching in OASIS

Caching (pronounced “cashing”) stores data replications that can be called for later use. OASIS provides the option for users to cache data on their local hard drive, which can help users working wirelessly or via VPN retrieve data more quickly. This article will cover:

• How Caching Works
• What Data is Cached
• Caching Implications
• How to Enable Caching
  • As an OASIS Admin
  • As a Non-Admin User

 

How Caching Works

Every time a user performs a search or opens an entry in OASIS, they generate a query. This query is sent to the database over the network to retrieve the data, and then it is sent back up to OASIS.

Most users who work in an office on the same network as the server hosting the OASIS database have no issues retrieving data this way. However, when a user works remotely on a VPN, wireless, or other connection, data may be returned more slowly because they are making calls to the database over the internet.

Caching can alleviate some of this slowness for remote users by storing data replications after it has been queried on their local hard drive, allowing the OASIS client to retrieve data from a file on their machine rather than the database.

Cached data will be stored in the ConnectionCache folder inside the .oasis folder. The ConnectionCache folder will not be created until caching is enabled.

Locating the ConnectionCache Folder on Windows

For Windows users, use the following file path to locate this folder: 

This PC\C:\Users\UserName\.oasis\ConnectionCache 

Locating the ConnectionCache Folder on Mac

For Mac users, follow the steps below to locate this folder. 

1. Open Finder by double-clicking the button. 

2. Click the Go menu at the top of the screen, then click Home. 

3. Click the Go menu at the top of the screen, then click Go to folder…

4. A search bar will appear. Type ".oasis" and click Go.

 

What Data is Cached

Information that tends to be more static or unlikely to change daily will be cached. Examples include:  

• Manufacturers
• Customers 
• Contacts 
• Workgroups

Transactions will not be cached due to how frequently they need to be changed and updated. Transactional data must be called from the database to ensure the user sees the most recent version. Examples of transactions include:  

• Quotes
• Orders 
• Invoices
• Payments

 

Caching Implications

Due to the nature of caching, it may appear as though edits to cached entries are not saving. This is because OASIS retrieves the cached information from the local ConnectionCache folder rather than making a new call to the database where the edits are being saved.

Edits will appear as soon as the user refreshes the ConnectionCache folder Refreshing the ConnectionCache folder will force OASIS to make a new call to the database and display the most recent information.

It's recommended that users refresh this folder after each monthly OASIS update to ensure that updates apply correctly. However, it can be refreshed at any time. 

Refreshing the ConnectionCache Folder

To refresh the ConnectionCache folder, delete it from the .oasis folder. OASIS will recreate the folder the next time OASIS is launched.

Note: OASIS may return results more slowly after the ConnectionCache folder is deleted. This is because OASIS must make new calls the database before it can be stored locally. However, once the information is cached, users should see an improvement in speed.  

 

How to Enable Caching as an OASIS Admin

1. Navigate to the Configuration page. 

2. Select Software from the drop-down list.

3. Under the Workstation Configuration section, click Preferences.

4. The Workstation Settings window will appear. 

5. Click the Database tab.

6. Check the Cache database calls box. 

7. Click Ok.

8. Restart OASIS to allow this change to take effect.

 

Enabling Caching as a Non-Admin User

The setting that controls caching is stored in the user's preference file on the local hard drive. Users can modify the preference file directly to enable caching.

Locating the Preferences File on Windows

For Windows users, use the following file path to locate the preferences file: 

This PC\C:\Users\UserName\.oasis\preferences

Once located, open the preference file in a text editor.

Locating the Preferences File on Mac

For Mac users, follow the steps below to locate the preferences file:

1. Open Finder by double-clicking the button. 

2. Click the Go menu at the top of the screen, then click Home. 

3. Click the Go menu at the top of the screen, then click Go to folder…

4. A search bar will appear. Type ".oasis" and click Go.

5. Open the preference file using a text editor.

Modifying the Preferences File

1. To enable caching, locate the line that reads:

UseDBCache=""

2. Between the quotation marks, type "Y". The line will now read:

UseDBCache="Y"

3. Save the preferences file to the .oasis folder.

4. Restart OASIS.