Perf05
Perf05
Author:
Jeffrey R. Parsons, Raima Sr. Engineer
Date:
2012

Description

EXAMPLE - Perf05

The Perf05 example performs a series of insert operations with varying transaction block sizes. The inserts are into very simple database schema using the RDM Core C APIs.

Each time you run this example

Database

The DDL (Database Definition Language) specification for the database used in this example is located in the file perf05_db.sdl. The example utilizes the SQL DDL syntax and specifies an in-memory database with a single table (simple). The table has a single column (int_col). There are no index definitions for this database.

--
--
-- Raima Database Manager
--
-- Copyright (c) 2012 Raima Inc., All rights reserved.
--
-- EXAMPLE - perf05
--
-- This is the SDL (SQL Database Definition Language) for a single column,
-- single table-type database. The one table is called simple,
-- and it's one field, int_col, is not indexed and can store a 32-bit integer.
CREATE DATABASE perf05_db INMEMORY;
CREATE TABLE simple (
int_col INT
);

The schema was compiled using the RDM rdmsql utility with the -c option to generate an embedded database dictionary (used by the RDM d_open_ptr API).

rdmsql -c perf05_db_db.sdl

The database dictionary information is embedded inside the application so an external DBD file stored on the file system is not required.

Functions Used

The following RDM functions are illustrated:

They are fully documented in http://docs.raima.com/rdm/.