Fully managed cloud. 30-day FREE full featured trial. Start Now
cancel
Showing results for 
Search instead for 
Did you mean: 

TPC-H Data Vault test on Exasol 7.0 beta

ADoerr
SQL-Fighter

Hi all,

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.

 

Conditions:

- 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:

ADoerr_0-1594898820158.png

 

The performance improvement for the direct Raw DV queries is already really good,

but the improvement on the virtualized dimensional model is just suprising.

 

 

 

 

 

10 REPLIES 10

exa-Carsten
Moderator
Moderator

TPCH_10GB_DefaultVsExperimental.png

Out of curiosity, I did a little benchmark with the hash type TPCH Data Vault model on 7.0.rc1 using some dedicated hardware and scalefactor 10. While for most queries, the execution times were pretty identical, there are three queries, where performance actually improved (5, 7 & 21), but also three where it degraded (2, 9 and 17). Each query was executed 5 times with each optimizer, the timings in the chart are then the averages of the 2nd - 5th execution (see attached script). I haven't looked at the query profiles yet, that's still on my todo list...