Raima Database Performance Testing – Database Samples

Click a download link below to test database performance.

Back to Home Page »

What is a Database Sample?

It’s a taste of the real thing, database performance tests of our product RDM that you can run on your computer. These are fully contained, downloadable samples that show the database performance in your environment using our system’s libraries. Duration = 5 minutes or less.

Core API

Only the Core API lists all database performance samples.

C/C++ For Windows C/C++ For Linux 32-bit C/C++ For Linux 64-bit Description
Performance 1 Performance 1 Performance 1 Simple record type, integer field, in-memory. Time creation of 50,000 records. Time scanning and summing of all records’ integer field. Time deletion of all records.
Performance 2 Performance 2 Performance 2 Same as previous but on-disk.
Performance 3 Performance 3 Performance 3 In-memory. Simple record type, integer field, one key. Time creation of 50,000 records. Scan through the key, verify ascending order. Time. Time deletion of all records.
Performance 4 Performance 4 Performance 4 On-disk. Same as previous.
Performance 5 Performance 5 Performance 5 In-memory. Same as first but with transactions of increasing batch size.
Performance 6 Performance 6 Performance 6 On-disk. Same as previous.
Performance 7 Performance 7 Performance 7 Hierarchy of sets. Bill-Of-Materials-like build followed by scan. Time each phase.
Performance 8 Performance 8 Performance 8 Hierarchy, same as previous, built from foreign/primary keys. Build, scan in same order. Time.
Performance 9 Performance 9 Performance 9 Multi-user. Spawn writer and reader threads. Writer creates X records per transaction. Reader sums a range of them each cycle. Use locking. Time.
Performance 10 Performance 10 Performance 10 Same as previous but reader uses MVCC read-only-transactions, not locks.

Core API Documentation

RDMSQL API

C/C++ For Linux 32-bit C/C++ For Linux 64-bit Description
Performance 1 Performance 1 Simple record type, integer field, in-memory. Time creation of 50,000 records. Time scanning and summing of all records’ integer field. Time deletion of all records.
Performance 2 Performance 2 Same as previous but on-disk
Performance 6 Performance 6 In-memory. Simple record type, integer field, one key. Time creation of 50,000 records. Scan through the key, verify ascending order. Time. Time deletion of all records with transactions of increasing batch size.
Performance 9 Performance 9 Multi-user. Spawn writer and reader threads. Writer creates X records per transaction. Reader sums a range of them each cycle. Use locking. Time.
Performance 10 Performance 10 Same as previous but reader uses MVCC read-only-transactions, not locks.

RDMSQL API Documentation

ADO.NET API

C/C++ C# Visual Basic F# Description
Performance 1 Performance 1 Performance 1 Performance 1 Simple record type, integer field, in-memory. Time creation of 50,000 records. Time scanning and summing of all records’ integer field. Time deletion of all records.
Performance 2 Performance 2 Performance 2 Performance 2 Same as previous but on-disk
Performance 6 Performance 6 Performance 6 Performance 6 In-memory. Simple record type, integer field, one key. Time creation of 50,000 records. Scan through the key, verify ascending order. Time. Time deletion of all records with transactions of increasing batch size.
Performance 9 Performance 9 Performance 9 Performance 9 Multi-user. Spawn writer and reader threads. Writer creates X records per transaction. Reader sums a range of them each cycle. Use locking. Time.
Performance 10 Performance 10 Performance 10 Performance 10 Same as previous but reader uses MVCC read-only-transactions, not locks.

ADO.NET API Documentation

ODBC API

C/C++ For Linux 32-bit C/C++ For Linux 64-bit Description
Performance 1 Performance 1 Simple record type, integer field, in-memory. Time creation of 50,000 records. Time scanning and summing of all records’ integer field. Time deletion of all records.
Performance 2 Performance 2 Same as previous but on-disk
Performance 6 Performance 6 In-memory. Simple record type, integer field, one key. Time creation of 50,000 records. Scan through the key, verify ascending order. Time. Time deletion of all records with transactions of increasing batch size.
Performance 9 Performance 9 Multi-user. Spawn writer and reader threads. Writer creates X records per transaction. Reader sums a range of them each cycle. Use locking. Time.

ODBC API Documentation

Object Oriented APIs

C++ For Windows Description
Performance 1 Simple record type, integer field, in-memory. Time creation of 50,000 records. Time scanning and summing of all records’ integer field. Time deletion of all records.

Object Oriented C++ API Documentation
Object Oriented C API Documentation

Instructions

  1. Download the sample.
  2. Run it - it produces timings in milliseconds..
  3. "Wow, that's fast!"
  4. Optionally build it - watch it in your debugger.
  5. Delete it
Hello World Database Samples

Note: Samples are pre-built, but come with complete project files and source code. Windows samples require Visual Studio 2008 or 2010 and Linux samples require a standard Linux development environment.

Full Product Download