Forum Discussion
Super UserLakehouse vs Warehouse performance
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
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/
2 Replies
- FabianSchut
Solution Sage
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/
SrisakthiThank 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