www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Server Administration
Data Access Interfaces
SQL Reference
SQL Procedure Language Guide
Database Event Hooks
Data Replication, Synchronization and Transformation Services
Web Application Development
XML Support
RDF Database and SPARQL
Web Services
Runtime Hosting
Internet Services
Free Text Search
TPC C Benchmark Kit
Building the Test Database
Using the Test Program
Tuning Parameters and Number of Users
Omissions, Exceptions from the Definition
Sample Configuration
Other Factors
TPC C Procedures
DDL Statements
Stored Procedures
Using Virtuoso with Tuxedo
Appendix
Virtuoso Functions Guide

Abstract

The Virtuoso TPC C Kit is a database benchmark written in C and SQL stored procedures using the CLI or ODBC API. It is modeled after the industry standard Transaction Processing Performance Council (TPC) C benchmark and can be used as a component in an official benchmark but does not in itself constitute a complete test driver.

See Also:

A complete description of the benchmark and its metric can be found at the TPC Web Site. This document assumes the reader is familiar with the general content of the benchmark.

The C and SQL source of the benchmark is contained in the sample directory of the Virtuoso tree. The tpcc executable is built by running make after choosing the target (see makefile).

Table of Contents

19.1. Building the Test Database
19.2. Using the Test Program
19.3. Tuning Parameters and Number of Users
19.4. Omissions, Exceptions from the Definition
19.5. Sample Configuration
19.6. Other Factors
19.7. TPC C Procedures
19.7.1. Introduction
19.7.2. New Order
19.7.3. Payment
19.7.4. Delivery
19.7.5. Order Status
19.7.6. Stock Level
19.8. DDL Statements
19.9. Stored Procedures