Software-based BLC is CPU-intensive. When using BLC on Teradata appliance systems with a high CPU capacity, you can do the following:
- 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.
Operations such as queries, insert/updates, dump/restores, and reconfig can use considerably more CPU while operating on compressed tables. Unless the system is CPU-rich, these operations impact other workloads and may lengthen elapsed response times.