topic Re: Lakehouse vs Warehouse performance in Data Warehouse

Lakehouse vs Warehouse performance

Srisakthi — Mon, 02 Dec 2024 07:46:54 GMT

Hello All,

Lakehouse supports optimization techniques like v-order, vaccum, liquid clustering, partitioning and it feels like it will give better performance when we build report on top of it. But warehouse lack few features like liquid clustering, partitioning will it affect performance on reporting?

Is there any benchamarking for performance of lakehouse vs warehouse.

Anonymous

frithjof_v any help is much appreciated and it will help me to take decision on to go with Lakehouse vs warehouse

Regards,

Srisakthi

Re: Lakehouse vs Warehouse performance

FabianSchut — Mon, 02 Dec 2024 14:23:47 GMT

Hi,

Microsoft has quite some documentation in choosing between lakehouses or warehouses:
https://learn.microsoft.com/en-us/fabric/get-started/decision-guide-lakehouse-warehouse
https://learn.microsoft.com/en-us/fabric/get-started/decision-guide-data-store

However, those are not always focussing on performance. This article desribes the difference in performance better for several use cases:
https://sqlreitse.com/2024/05/31/testing-azure-fabric-capacity-data-warehouse-vs-lakehouse-performance/

Re: Lakehouse vs Warehouse performance

Srisakthi — Wed, 04 Dec 2024 05:49:30 GMT

Thank youso much FabianSchut ,

The last link on performance article gives good view and it will help everyone for considering lakehouse or warehouse.

thanks again!

Regards,

Srisakthi