Local database access

Local database access is the fastest way of accessing an ODABA database. However, local database access requires exclusive database access.

Local database access is the preferred access mode for running maintenance jobs (e.g. copying or checking a database).

Local database access is indicated by defining NET= NO in the data source definition. It does not matter (except access speed) whether the database file(s) is located on a drive in the local network, in the internet or on a local computer drive.

In order to improve performance, one may enable the root base cache by defining a [ CACHE ] section in the ini-file or by calling Application ::sharedDatabase( true ) in the application program before opening may database. Within the [ CACHE ] section may (but need not) define additional cache options. When activating the root base cache, instance descriptors (and instances) are cached. When root base cache is enabled, resource locks are managed via the root base cache (between threads) and the application can be run in multiple thread mode.

Local database access the best ways of triggering database events since there are no other processes, which may cause events.