Re: Transaction benchmarks

From: Doug Rady <drady_at_uucp>
Date: 26 Mar 93 01:48:17 GMT
Message-ID: <1993Mar26.014817.20842_at_oracle.us.oracle.com>


In article <C4GEHo.9Gw_at_cbnewsc.cb.att.com> kit_at_cbnewsc.cb.att.com (shailesh.bhobe) writes:
>Hi:
>
>Can someone please help me find the specifications of the various
>"standard transactions" that are often touted when quoting benchmark
>figures.
>
>I need to know exactly WHAT constitutes a transaction in terms
>of sizes of relations, indexes on them, number of tuples affected
>in the transaction etc. etc.
>
>Thanks for the help.
>
> shailesh bhobe
> att!psp!smb2
> (708) 979-7101

There are many benchmarks running around. The TPC-A, TPC-B, TPC-C benchmarcs are from the Transaction Processing Council (TPC) and are administered by:

    Shanley Public Relations
    777 N. First Street, Suite 600
    San Jose, CA 95112-6311
    voice: 408.295.8894
    fax: 408.295.2613
    e-mail: shanley_at_cup.portal.com

Some of the TPC benchmark specifications are available via anonymous FTP from dg-rtp.dg.com
They request that you do your ftp'ing during the off hours. The following files are currently available:

-rw-rw-r--   1 602  602      1557 May  4  1992 AA-Index
-rw-r--r--   1 602  602    985893 Nov 22 21:55 TPC-CPSp.1-36
-rw-rw-r--   1 602  602    156160 Feb 24  1992 TPCARev1.1
-rw-rw-r--   1 602  602    834379 Feb 27  1992 TPCARev1.1-PS
-rw-rw-r--   1 602  602    247648 Feb 24  1992 TPCARev1.1-RTF
-rw-r--r--   1 602  602     77761 Mar 17 09:09 TPCA_results_sylk.3.12.93
-rw-rw-r--   1 602  602    159340 Feb 27  1992 TPCArev1.1-WP
-rw-r--r--   1 602  602     46603 Mar 17 09:10 TPCB+C_results_sylk.3.12.93
-rw-rw-r--   1 602  602    128000 Feb 24  1992 TPCBRev1.1
-rw-rw-r--   1 602  602   1016600 Feb 27  1992 TPCBRev1.1-PS
-rw-rw-r--   1 602  602    197711 Feb 24  1992 TPCBRev1.1-RTF
-rw-rw-r--   1 602  602     74303 May  4  1992 TPCBylaws
-rw-r--r--   1 602  602    312448 Nov  4 14:06 TPCCRev1.0
-rw-r--r--   1 602  602    436008 Nov  2 22:19 TPCCRev1.0-RTF
-rw-rw-r--   1 602  602      2056 Feb 27  1992 intro_to_ftp

doug.



drady_at_us.oracle.com they pay me to code for them, not speak for them. Received on Fri Mar 26 1993 - 02:48:17 CET

Original text of this message