microsoft / microsoft/vscode-mssql

[Bug]: Object Explorer freezes with large number of tables

Open
#21,817 0 comments 0 reactions 1 assignee Claimed by @aasimkhan30 View on GitHub
Area - Object Explorer Bug User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

### Description

Expected the MSSQL extension to load the tables for my database.
But instead it just sat 'Loading' forever
There are a large number of tables (over 116k)

### Steps to Reproduce

1. Connected to database
2. Expanded tables
3. First time got 'error loading'
4. Hit refresh
5. Waited and waited and waited... but never returned just sat 'Loading' for over 15 minutes

### Affected Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [x] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the affected area

_No response_

### Environment Information

VS Code version 1.113.0
Extension version 1.41.0

### Confirmation

- [x] I have searched existing issues and couldn't find a match
- [ ] I want to work on this issue

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.