QVD Segmentation 2.0 – Speeding Up QVD Partitioning by up to 5x

By |2023-11-21T18:01:49-06:00September 30th, 2019|Development, Lean Data Processing, Optimization, Qlik Sense, QlikView, Tools|

One of the tools I’ve developed as part of the Lean Data Processing Framework is an optimized implementation of the QVD Segmentation technique. This technique is typically used in Qlik Deployments that deal with large datasets, and allows us to split a large table into multiple QVD files. For example, storing one QVD for each month of data, rather than storing the entire dataset in a single file. While this technique has always been around, and other implementations exist that perform the same operation, the modified version that I’m sharing today focuses on reducing the time it takes for the process to complete by avoiding over-processing, and reducing the motion of data required in the process.