Closing Databases

Once you are done using the database, you must close it. You use the DB->close() method to do this.

Closing a database causes it to become unusable until it is opened again. It is recommended that you close any open cursors before closing your database. Active cursors during a database close can cause unexpected results, especially if any of those cursors are writing to the database. You should always make sure that all your database accesses have completed before closing your database.

Cursors are described in Using Cursors later in this manual.

Be aware that when you close the last open handle for a database, then by default its cache is flushed to disk. This means that any information that has been modified in the cache is guaranteed to be written to disk when the last handle is closed. You can manually perform this operation using the DB->sync() method, but for normal shutdown operations it is not necessary. For more information about syncing your cache, see Data Persistence.

The following code fragment illustrates a database close:

#include <db.h>
DB *dbp;           /* DB struct handle */

 * Database open and access operations
 * happen here.


/* When we're done with the database, close it. */
if (dbp != NULL)
    dbp->close(dbp, 0);