www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
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 Data Access and Data Management
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

20.1. Building the Test Database
20.2. Using the Test Program
20.3. Tuning Parameters and Number of Users
20.4. Omissions, Exceptions from the Definition
20.5. Sample Configuration
20.6. Other Factors
20.7. TPC C Procedures
20.7.1. Introduction
20.7.2. New Order
20.7.3. Payment
20.7.4. Delivery
20.7.5. Order Status
20.7.6. Stock Level
20.8. DDL Statements
20.9. Stored Procedures