search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 898 forks source link

Slow performance on notebook with many interspersed Markdown and SQL code cells #17623

Open dullroar opened 2 years ago

dullroar commented 2 years ago

Other stuff pasted from "About":

Commit: b8629acc4b343592d3fa9aabdada5aadc1f57ddd Date: 2021-11-05T05:31:07.073Z VS Code: 1.58.0 Electron: 12.0.9 Chrome: 89.0.4389.128 Node.js: 14.16.0 V8: 8.9.255.25-electron.0

@chlafreniere - tagging you per our discussion on bug #17579.

Steps to Reproduce:

  1. Create complex notebook (ca. 156 cells, fairly evenly distributed between Markdown and SQL code cells) for colleagues in related shops that shows for each attribute of interest in our similar CRM systems some commentary and then one or a few generic data quality queries and results ("Birthdates in the future," that sort of thing). Most of the result sets are small. Fall in love with everything about notebooks and Azure Data Studio.
  2. Save notebook and close ADS.
  3. Reopen ADS and notebook (it will probably be defaulted if it was open when ADS was closed, which makes ADS then appear "hung"). Notebook will take several minutes to render, with many "Reopen," "Wait" or "Close" popups in between. Still in love, but now with "morning breath." :)

Does this issue occur when all extensions are disabled?: Yes

chlafreniere commented 2 years ago

@lucyzhang929 can you take a look?