Forum Discussion
Why does SQL Server return some rows during query execution but Lakehouse in Fabric doesn't?
Hi Anonymous ,
I don't think it's a problem with my workspace, I wish it were.
It is clearly a general problem as the performance of the Azure Synapse Serveless Pools is superior to that of the Fabric SQL endpoints and furthermore the Azure Synapse serveless pools guarantee, like the other databases, the incremental fetch of the response while in the Fabric SQL endpoint this does not happen by having to wait for the query to complete before getting the response.
Thanks anyway for the attempt to support
Greetings
Hi marcoG ,
We didn't get any update from internal team. I will get back to you as soon as we have an update.
Appreciate your patience.
Hi marcoG ,
Apologies for the issue that you are facing.
This might require a deeper investigation from our engineering team about your workspace and the logic behind it to properly understand what might be happening.
Please go ahead and raise a support ticket to reach our support team:
https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.
Hi Anonymous ,
I don't think it's a problem with my workspace, I wish it were.
It is clearly a general problem as the performance of the Azure Synapse Serveless Pools is superior to that of the Fabric SQL endpoints and furthermore the Azure Synapse serveless pools guarantee, like the other databases, the incremental fetch of the response while in the Fabric SQL endpoint this does not happen by having to wait for the query to complete before getting the response.
Thanks anyway for the attempt to support
Greetings