SQL Server connection takes several minutes and blocks DBCode since v1.36.11

[WesleyDieterich]

Bug Description

Starting with DBCode version 1.36.11, connecting to a SQL Server database takes several minutes before the connection is established. During this period, the entire DBCode extension becomes unresponsive and cannot execute any other queries or operations. 1.36.10 works just fine.

This behavior did not occur in previous versions.

Repro steps

1. Open VS Code with DBCode installed.
2. Configure and open a SQL Server connection.
3. Attempt to connect to the SQL Server database.
4. Observe that the connection remains in a loading state for several minutes.
5. During this time, try to execute another query or use another DBCode connection.
6. See that the DBCode extension is blocked until the SQL Server connection finishes loading.

Expected Behavior

The SQL Server connection should be established normally without blocking the rest of the DBCode extension. Other connections and queries should remain usable while a connection is being established.

Actual Behavior

The SQL Server connection takes several minutes to connect. While it is loading, the entire DBCode extension becomes unresponsive and cannot execute other queries or operations.

Environment

• DBCode version: 1.36.11
• VS Code (or fork) version: 1.134.0
• OS: Windows 11
• Database: SQL Server 2016
• Connection: [direct/SSH/SSL]

Error Meesages (if applicable)

No error message is displayed. The connection remains loading for several minutes.

Screenshots

Logs

[mikeburgh]

I added synonyms in that release… only thing I think might have caused the speed hit was if you had some point to remote servers ? (Didn't realize that was a thing)

I just released 1.36.13 which skips those in the initial introspection.. can you give it a try and see if it's fixed ?

If not I will give you some sql to run if you don't mind and we can track down where it's dragging..