Traditional methods of remote access can create performance bottlenecks that may severely impact applications. Whether for internal use, commercial projects, web, or mobile applications, slow performance can quickly result in project failure. Accessing data from any remote source can cause several common issues:

• Network Connections – Mobile applications often face slow network connections and latency issues.
• Service Delays – Interruptions due to server hardware or software updates can cause delays.
• Large Data – Requests for large data volumes, whether intentional or unintentional.
• Disconnects – Complete loss of network connectivity.

The ODBC Driver for Intacct addresses these problems with smart caching technology, significantly enhancing performance and minimizing application bottlenecks.

Smart Caching

Smart caching is a configurable feature that stores queried data in a local database. When enabled, it creates a persistent local cache database that replicates the data retrieved from the remote source. This cache database is small, lightweight, and extremely fast, allowing multiple connections to share it as persistent storage.

Caching options available with our ODBC Drivers include:

• Auto Cache – Automatically maintains a local cache for all data requests. Each time a SELECT query is executed, data is loaded into the cache database, updating the corresponding table as needed.
• Explicit Cache – Developers have full control, deciding what data is cached and when it is updated using explicit CACHE statements.
• No Cache – Data is accessed live without creating a local cache file.

This caching functionality boosts application performance, allowing applications to disconnect and continue limited operations without needing additional code for local storage or data serialization/deserialization.

For more details on ODBC Driver caching and best caching practices, consult the included help files.