Store large volumes of indexed text in BLOBs with compression
Compress Indexed Text in BLOBs
Valentina DB has built in support for ZIP compression which is extremely useful for storing very large objects. Compressed text with ZIP compression applied produces an average of 7:1 compression (a 7 GB text data reduced to 1 GB). But what about text you want to have indexed for search purposes? In order to index compressed text, the database engine itself must uncompress value, extract words and add them to the index. Valentina DB has this ability built into it.
|Valentina DB lets you set a a flag for the VTEXT field (a sub-class of VBLOB), which can also be indexed to automatically compress or decompress text stored in the BLOB.