CPU Considerations on Different Teradata Platforms - Teradata Database

Teradata Database Design
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

CPU Considerations on Different Teradata Platforms

Because software-based BLC is CPU-intensive, consider the CPU capabilities of the particular Teradata Database platform when using it. When using BLC on the Teradata 1650 and 2650 systems, which offer very high CPU capabilities, you can:

  • Apply BLC to all allowable types of data.
  • Load and access data at any time, because there is enough available CPU to frequently decompress data.

    • When using software-based BLC on other platforms with less CPU capacity, you may need to:

  • Load tables during off-peak hours.
  • Limit access to compressed tables during critical throughput periods.

    • Some operations (including queries, insert/updates, ARC dump/restores, reconfig, and CheckTable) can use considerably more CPU while operating on compressed tables. Unless the system is very CPU rich, these operations will impact other workloads and could lengthen elapsed response times.