Most of VSCode hangs when a large sql file is open

[Anutrix]

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
  • [x] MySQL/MariaDB
  • [ ] MSSQL/Azure
  • [ ] SQLite
  • [ ] Other? Which...
• Database version: MySQL 5.x

[vl85]

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.