Use in-memory mode

If your application can tolerate the loss of committed transactions after the most recent checkpoint, then your application
may benefit from using in-memory mode.

This mode is useful in applications where increased performance is desirable, and you are running on a system with a large
amount of available memory, typically enough to hold all the database files within the cache.

You can choose between two different in-memory modes. In never-write mode, committed transactions are not written to the database
file on disk. When you specify never-write mode, multiple concurrent LOAD TABLE statements can be active on the same or different
tables. All changes are lost if the database is shut down or the connection is lost. In checkpoint-only mode, the database
server does not use a transaction log, and you cannot recover to the most recent committed transaction. However, because the
checkpoint log is enabled, the database can be recovered to the most recent checkpoint.