Issue Details (XML | Word | Printable)

Key: CORE-4401
Type: Improvement Improvement
Status: Open Open
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 3
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Optimize the record-level RLE algorithm for a denser compression of shorter-than-declared strings and sets of subsequent NULLs

Created: 24/Apr/14 11:51 AM   Updated: 07/Aug/17 08:18 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 4.0 Beta 1


 Description  « Hide
The RLE algorithm used by the engine compresses sets of up to 128 equal bytes into two bytes. This means that every empty (or NULL) VARCHAR(32000) is compressed into 500 bytes. This storage overhead is too big. The same issue applies to many shorter fields that are all NULLs -- they along with their padding also represent the long chain of zero bytes that cannot be compressed more efficiently than with a 64x ratio.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.