|
C:\omnidex\Demodata>ODXSQL
DS73013 2.0.00 ODXSQL - Omnidex SQL Mon Jun 04 15:45:00 2001
(c) Dynamic Information Systems Corp. 1981-2001
LICENSEE: ** Client Copy **
> BENCHMARK
Benchmark profiles:
1. STAR.ORDERS_SVW
2. STAR.ORDERS
3. STAR.PROSPECTS
4. STAR.PROSPECTS_ROLLUP
5. CUSTOM
Enter profile [1]: 5
Enter the environment catalog to test against. If OdxSql
is already connected to an environment catalog, press enter.
Follow the prompts through the rest of the test.
Environment file: ORDERS.ENV
Database: ORDERS
Table: CUSTOMERS
Columns: *
Criteria:
Select options:
Max rows:
Connected to ORDERS.ENV
Benchmark table ORDERS.CUSTOMERS has 16 columns
and a 356 byte record length
Test Series Menu
1 System Benchmarks
2 Database Retrieval Benchmarks
Enter tests to execute, or ? for help: ?
The following commands are supported. Note that multiple
test series may be specified in one command separated by spaces:
(P)rofile Specify a profile
n.n.n Execute test series
n.n.* Execute all tests within 'n.n'
n.n If a test category, execute all tests in category
* Execute all tests
> Expand menu
>> Expand menu to maximum
< Contract menu
<< Contract menu to minimum
? Help
EXIT Exit program
Test Series Menu
1 System Benchmarks
2 Database Retrieval Benchmarks
Enter tests to execute, or ? for help: >
Test Series Menu
1 System Benchmarks
1.1 POSIX File I/O Benchmarks
2 Database Retrieval Benchmarks
2.1 Baseline
2.2 Sequential Reads
2.3 Random reads
2.4 Exports
Enter tests to execute, or ? for help: >>
Test Series Menu
1 System Benchmarks
1.1 POSIX File I/O Benchmarks
1.1.1 Sequential Writes
1.1.2 Sequential Reads
1.1.3 Random Writes
1.1.4 Random Reads
2 Database Retrieval Benchmarks
2.1 Baseline
2.1.1 Database Caching
2.1.2 Database I/O
2.1.3 DataAccess Driver I/O
2.2 Sequential Reads
2.2.1 OmniAccess Sequential Reads
2.2.2 OmniAccess Sequential Reads 10X
2.2.3 DBINSTAL
2.3 Random reads
2.3.1 OmniAccess Rowid Reads
2.3.2 OmniAccess Rowid Reads 10X
2.3.3 OmniAccess Primary Key Reads
2.3.4 OmniAccess Primary Key Reads 10X
2.4 Exports
Enter tests to execute, or ? for help: 2
Host: CALNT - 6 (Intel Pentium II) Windows_NT
V4.0 1381 Service Pack 6
Memory: 127 MB
Version: 3.7 Build 5F
Date: Mon Jun 04 15:45:33 2001
TMPDIR: C:\TEMP
Benchmark File Total Each Qty CPU Elapsed Rate
Comp
DBMS Cache 346K 346K 356 996 0.000 0.000 0.0M/s ----
DBMS 346K 346K 356 996 0.000 0.000 0.0K/s 1.00
DA Driver 346K 346K 356 996 0.000 0.000 0.0K/s 0.00
OA 346K 346K 356 996 0.050 0.050 6.8M/s 0.00
OA 10x 346K 346K 356 996 0.020 0.020 16.9M/s 0.00
DBINSTAL 346K 346K 356 996 0.010 0.010 33.8M/s 0.00
OA Rowid 346K 3K 356 9 0.000 0.000 0.0K/s 0.00
OA Rowid 10x 346K 3K 356 9 0.000 0.000 0.0K/s 0.00
OA Pri Key 346K 3K 356 9 0.010 0.010 312.9K/s 0.00
OA Pri Key 10x 346K 3K 356 9 0.020 0.020 156.4K/s 0.00
OA Export 346K 346K 356 996 0.030 0.040 8.5M/s 0.00
top
|
