- 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.
- Load tables during off-peak hours.
- Limit access to compressed tables during critical throughput periods.
Some operations (including queries, insert/updates, 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.