Perf05

- Main Page
- Files

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

- The database is initialized (removing all existing data)
- 50,000 new records are created using different transaction block sizes
  - 50,000 10,000 5,000 1,000 500 100
- Database is cleaned up

# 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:

- d_tfsinitEx/d_tfsterm
- d_opentask/d_closetask
- d_initialize
- d_open/d_close
- d_fillnew
- d_trbegin/d_trend
- d_errorname
- d_errorstr

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