Demonstrates opening, connecting to, populating and closing a multifile database. Note that, in addition to the four memory devices commonly defined for persistent storage applications, two additional devices are defined for added database storage. And all the database storage devices are defined as type
MCO_MEMORY_MULTIFILE
. Also note the use of functionmco_disk_transaction_policy()
to set theNO_SYNC
transaction policy (to speed transactions) and the call of functionmco_execute_statement()
to insert database objects.
See instructions here on how to build this and other samples on your development platform. Once built, the sample can be run from the
\target\bin
directory:api_sql_01_c_api_multifileBut it is more instructive to run it in your development environment debugger, stepping through the code.