Example Benchmark 2: Materialization Cost Over Remote Network - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software

The fetch details for this benchmark are:

  • Mule fetch size: 10M
  • Row size: 5KB
  • Total number of rows: 200K
  • Total data size: 1GB
  • Network: Beijing to United States
  • Autocommit: ON
    Materialization Cost Over Remote Network
    Fetch Count Compression ON (ms) Compression OFF (ms)
    10 1208 1377
    50 1519 1694
    100 1847 2116
    500 5226 5515
    1000 9462 9806
    2000 19776 23177