microsoft / vscode-mssql

Visual Studio Code SQL Server extension.
Other
1.55k stars 458 forks source link

Query results grid doesn't support progressive results stream #18252

Open kburtram opened 1 month ago

kburtram commented 1 month ago

Steps to Reproduce:

  1. Run a query that takes a long time to run and returns rows progressively, For example, below.
SELECT *
FROM sys.objects AS o1
CROSS JOIN sys.objects AS o2
CROSS JOIN sys.objects AS o3;

Expected: Results are displayed as the arrive, perhaps in batches, but progressively as the query executes.

Actual: The results don't display until the query is done, and it takes a long, long, long time for queries like this to complete relative to other client tools.

caohai commented 1 month ago

This behavior (same with the old angular implementation) comes from the way we currently sets up query execution events. I should be able to fix this without breaking the old experience.