wanted to share a small performance test, we made with the new Exasol 7.0 beta.
I was very curious how big the impact of the new Hash datatype would be.
- Exasol 6.2.7 community edition vs. Exasol 7.0 beta community edition
- both 4GB Ram
- TPC-H scalefactor 1
- persistent Raw Data Vault
- virtualized dimensional model
- query cache disabled
These are the results:
The performance improvement for the direct Raw DV queries is already really good,
but the improvement on the virtualized dimensional model is just suprising.