Gilbert Quevauvilliers provides some more comparisons:
I learnt a lot and based on the feedback people asked for me to compare the Lakehouse vs the Warehouse with 1 billion rows.
What I also did this time was to optimize anything I could with regards to loading data into the Lakehouse or the Warehouse based on the feedback I received.
Below is a list of the changes I made
Read on for those changes and how they affected performance. That’s the tricky part about performance comparisons: unless you know how to tweak all options equally, you can end up with skewed results.
I’d also be interested in how the Eventhouse fares. I believe that, when it comes to data retrieval, the Eventhouse is the fastest option available to us.