Home › Forums › kdb+ › Compression for null string column › Reply To: Compression for null string column
-
Thanks @rocuinneagain , will test.
FYI we’d also tested changing the type from string to symbol, the symbol column compresses at the same ratio as in your example
q)show c:count get`:eohara_dev/strCol 18809996 q)vals:
sym?c#
q)symsymbol$() q)(
:eohara_dev/test;17;2;5)set vals
:eohara_dev/test q)-21!
:eohara_dev/test
compressedLength | 257281
uncompressedLength| 150484064
algorithm | 2i
logicalBlockSize | 17i
zipLevel | 5iq)150484064%257281
584.9016