Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Most of VSCode hangs when a large sql file is open #989

Open
1 of 5 tasks
Anutrix opened this issue Sep 23, 2022 · 1 comment
Open
1 of 5 tasks

Most of VSCode hangs when a large sql file is open #989

Anutrix opened this issue Sep 23, 2022 · 1 comment

Comments

@Anutrix
Copy link

Anutrix commented Sep 23, 2022

Describe the bug
VSCode doesn't freeze technically but practically.
All actions like global searching, git features, etc. just don't finish. As if they are waiting for some action to be finished. Making it unusable till restart.
Same issue when I just open any large(25000+ lines) .sql file in VSCode editor.
renderer1.log has:

[2022-09-15 01:06:03.179] [renderer1] [info] UNRESPONSIVE extension host: starting to profile NOW
[2022-09-15 01:06:08.316] [renderer1] [warning] UNRESPONSIVE extension host: 'mtxr.sqltools' took 88% of 5087.599ms, saved PROFILE here: '' [{"id":"gc","total":592679,"percentage":12},{"id":"mtxr.sqltools","total":4494678,"percentage":88},{"id":"self","total":135,"percentage":0}]

Closing and opening the folder/vscode fixes it until I open the large file again.
Same error is seen in rendered1.log after each slow down.

Using SQLTools with MySQL driver on Intel Mac.

To Reproduce
Steps to reproduce the behavior:

  1. Open any 25000+ line .sql file.

Expected behavior
No freeze.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

  • SQLTools Version: v0.25.1
  • VS Code Version: Latest version 1.71.x (same issue in older versions)
  • OS: Mac
  • Driver:
    • PostgreSQL/Redshift
    • MySQL/MariaDB
    • MSSQL/Azure
    • SQLite
    • Other? Which...
  • Database version: MySQL 5.x
@vl85
Copy link

vl85 commented Aug 2, 2023

Same here. Entity Framework Core migrate.sql file. Mac OS. PostgreSQL. SQLTools v0.28.0.
Have to close the file, restart VSCode. Can't merge the file properly.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants