Data compression business central

What is SQL data compression?

For rowstore tables and indexes, use the data compression feature to help reduce the size of the database.
In addition to saving space, data compression can help improve performance of I/O intensive workloads because the data is stored in fewer pages and queries need to read fewer pages from disk..

What is transformation rule in Business Central?

You define transformation rules for data exchange definitions by opening an existing definition, or creating a new definition, and then on the Line Definitions FastTab, choosing Manage, and then Field Mapping.
Predefined rules are provided, but you can also create your own..

Why do we want to compress data?

Compressed files require significantly less storage capacity than uncompressed files, meaning a significant decrease in expenses for storage.
A compressed file also requires less time for transfer while consuming less network bandwidth.
This can also help with costs, and also increases productivity..

The following are some common data compression methods: