Example Benchmark 1: Materialization Cost Over Local 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 Beijing
  • Autocommit: ON
    Materialization Cost Over Local Network
    Fetch Count Compression ON (ms) Compression OFF (ms)
    10 265 267
    50 245 272
    100 241 264
    500 289 282
    1000 341 338