Forum Discussion
Solved
Why does SQL Server return some rows during query execution but Lakehouse in Fabric doesn't?
In general there are some operators that require all rows to come to them before they can start processing them and pass them downstream, there are other operators that are able to start streaming or...
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 are reaching out to the internal team to get more information related to your query and will get back to you as soon as we have an update.