Caching a dataset or dataframe can be a very expensive operation, but has a huge benefit for later queries that use it. There are many use cases that could benefit from caching the data but not enough to justify the current scheme. I would like to propose that we make the serialization of the caching plugable. That way users can explore other formats and compression code.
As an example I took the line item table from TPCH at a scale factor of 10 and converted it to parquet. This resulted in 2.1 GB of data on disk. With the current caching it can take nearly 8 GB to store that same data in memory, and about 5 GB to store in on disk.
If I want to read all of that data and and write it out again.
But a query that reads that data directly from the cache after it is built only takes 21531 ms. For some queries having much more data that can be stored in the cache might be worth the extra query time.
It also takes about a lot less time to do the parquet compression than it does to do the cache compression.