Performance Benchmarks - 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

For the example benchmarks that follow, the server configuration is:

Commodity hardware:

  • physical servers: Dell C2100, Dell 720 XD
  • 1 queen, 2 workers, 1 loader

The client configuration is:

  • physical server

Benchmark terminology:

  • Materialization cost—Time taken to get the first result set. This is also the time the it takes for you to get control back, when the initial results are fetched.
  • Total fetch cost—Time taken to get the entire query result. Time taken to get the complete result set. This is equal to time taken (MC) * number of fetches.